Category Archives: Problem Resolution
-
Clean out all bad characters from a string.
9March 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 -
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?
Leave a commentMay 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
