Tag Archives: problem resolution

  1. Altering a column in a large table: A case study


    July 14, 2016 by Kenneth Fisher

    Fair warning, this is a discussion piece. I had a task, I went through several possibilities and I’m going to …
    Continue reading

  2. Comparing the contents of two tables Redux

    Leave a comment

    June 8, 2016 by Kenneth Fisher

    I did a post the other day on comparing two tables. It was meant as a general overview but I …
    Continue reading

  3. Pulling data from a non-clustered index


    March 14, 2016 by Kenneth Fisher

    This is one of those things that I found very interesting but figured I’d probably never really use. Of course …
    Continue reading

  4. ‘Twas 4:45 Friday

    Leave a comment

    December 23, 2015 by Kenneth Fisher

    I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents …
    Continue reading

  5. “That little green arrow.” or “My code used to work but now I’m getting a debug error.”


    October 15, 2015 by Kenneth Fisher

    If you’ve worked with SSMS for any length of time this will look awfully familiar: SSMS 2008R2 SSMS 2012 + …
    Continue reading

  6. Finding the error from a failed job.


    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 you …
    Continue reading

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

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

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

  10. Copying a TDE database from one instance to another


    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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,580 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013