Category Archives: Performance

  1. Is the network your last performance bottleneck?

    6

    July 18, 2016 by Kenneth Fisher

    Let’s say your company relies on the cloud for its servers (or maybe not, on premise networks have more options …
    Continue reading

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

    5

    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

  3. Comparing the contents of two tables

    13

    May 12, 2016 by Kenneth Fisher

    I’ve been working on tuning a query for the last week and I’ve had to make several changes to the …
    Continue reading

  4. The risks of Delayed Durability

    Leave a comment

    April 12, 2016 by Kenneth Fisher

    It’s T-SQL Tuesday again and this month we are hosted by Jens Vestergaard (b/t) who want’s us to talk about …
    Continue reading

  5. TOP 1 killed my performance; Rob Farley helped me resurrect it.

    15

    March 21, 2016 by Kenneth Fisher

    tl;dr; There is no short version of this. It’s LONG. It’s interesting but you might want to skip it if …
    Continue reading

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

  7. Yet one more quick and easy performance tuning setting

    1

    June 1, 2015 by Kenneth Fisher

    I blogged in the past about two simple commands that can be a big help in performance tuning SET STATISTICS …
    Continue reading

  8. Test first; Mileage may vary;

    2

    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

  9. ‘Twas 4:45 Friday

    3

    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. Two simple commands that can be a big help in performance tuning.

    6

    September 2, 2014 by Kenneth Fisher

    The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are …
    Continue reading

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

Join 1,223 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
Follow

Get every new post delivered to your Inbox.

Join 1,223 other followers