Category Archives: Problem Resolution
-
Test first; Mileage may vary;
2May 14, 2015 by Kenneth Fisher
I went to a SQL Saturday recently and saw a number of great sessions. If you haven’t been to a …
Continue reading -
Building a job to monitor other jobs
5May 4, 2015 by Kenneth Fisher
The other day Tom Roush (b/t) and Tim Radney (b/t) were having a discussion on twitter about using scheduled windows …
Continue reading -
Clean out all bad characters from a string.
10March 25, 2015 by Kenneth Fisher
I have a customer who is having a problem with a load. He is getting a fair number of bad …
Continue reading -
Dealing with layered function calls
5February 5, 2015 by Kenneth Fisher
T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are …
Continue reading -
Finding the reason for the error “Subquery returned more than 1 value”
1January 7, 2015 by Kenneth Fisher
First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In …
Continue reading -
SQL Judo’s Monthly Challenge – January 2014 – Restore the Master
5January 5, 2015 by Kenneth Fisher
Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
Continue reading -
‘Twas 4:45 Friday
2December 16, 2014 by Kenneth Fisher
‘Twas 4:45 Friday, and all through the office not a creature was stirring, not even the bosses. The code was …
Continue reading -
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
