Category Archives: Problem Resolution
-
The amazing never shrinking heap
Leave a commentAugust 25, 2014 by Kenneth Fisher
This is a quick demo of a little “trick” with heaps I’ve known about for a couple of years. However …
Continue reading -
Why am I getting a primary/unique key violation?
3July 23, 2014 by Kenneth Fisher
This may seem like a question with a simple answer but there is a bit more to it than you …
Continue reading -
T-SQL Tuesday #56: Assumptions
6July 8, 2014 by Kenneth Fisher
I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can …
Continue reading -
Who has the DAC open?
2May 28, 2014 by Kenneth Fisher
The other day I started seeing the following error in my SQL log. Error: 17810, Severity: 20, State: 2. Could …
Continue reading -
Start with stupid
2March 17, 2014 by Kenneth Fisher
True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked …
Continue reading -
Check your SQL Agent history settings before it’s too late!
9February 10, 2014 by Kenneth Fisher
A little while back I was doing some research into a failed job and ran into a slight problem. The …
Continue reading -
Negative session_ids
3January 27, 2014 by Kenneth Fisher
I probably had the most fun all week when a query I was running came up blocked. Sounds strange right? …
Continue reading -
Transactions: Who, What and Where
1January 20, 2014 by Kenneth Fisher
Recently we had a scenario where we had a handful of queries being blocked. Nothing unusual there but when I …
Continue reading -
A pattern to do beginning of period calculations.
Leave a commentNovember 20, 2013 by Kenneth Fisher
Beginning of period calculations are common things. Rolling month reports, queries to pull everything from last month etc require beginning …
Continue reading
SQL Studies 