Category Archives: Problem Resolution

  1. Finding the error from a failed job.

    Leave a comment

    October 7, 2015 by Kenneth Fisher

    This is a fairly simple one once you’ve seen it, but then so are lots of things :). Let’s say …
    Continue reading

  2. “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

  3. 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

  4. Blocking and deadlocking on purpose

    Leave a comment

    July 1, 2015 by Kenneth Fisher

    Blocking and deadlocking are not things you typically want to do deliberately. But sometimes you need to test error handling …
    Continue reading

  5. 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

  6. 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

  7. Building a job to monitor other jobs


    May 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

  8. 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

  9. 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

  10. 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


Get every new post delivered to your Inbox.

Join 806 other followers