Tag Archives: problem resolution

  1. “sql_handle” is not a recognized table hints option.

    Leave a comment

    September 23, 2015 by Kenneth Fisher

    I’ve you’ve run a query similar to the following: And gotten an error similar to: Msg 321, Level 15, State …
    Continue reading

  2. The 30 minute rule


    August 26, 2015 by Kenneth Fisher

    In one of my first IT jobs (back in the dark ages) we had something called the thirty minute rule. …
    Continue reading

  3. Pulling data from the error log


    August 17, 2015 by Kenneth Fisher

    The other day I was asked to pull a list of errors from the SQL Server log into a table …
    Continue reading

  4. Copying a TDE database from one instance to another

    Leave a comment

    June 22, 2015 by Kenneth Fisher

    I got my first real world experience with a TDE (transparent data encryption) database recently. For those who don’t know …
    Continue reading

  5. Test first; Mileage may vary;


    May 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

  6. Clean out all bad characters from a string.


    March 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

  7. Dealing with layered function calls


    February 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

  8. Finding the reason for the error “Subquery returned more than 1 value”


    January 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

  9. ‘Twas 4:45 Friday


    December 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

  10. The amazing never shrinking heap

    Leave a comment

    August 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


Get every new post delivered to your Inbox.

Join 806 other followers