Category Archives: Performance

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

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

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

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

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

  6. T-SQL Tuesday #49: Wait for it

    3

    December 10, 2013 by Kenneth Fisher

    It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits. …
    Continue reading

  7. A better way to find missing indexes

    11

    November 11, 2013 by Kenneth Fisher

    I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a …
    Continue reading

  8. Physical Join Operators by Ami Levin

    Leave a comment

    November 6, 2013 by Kenneth Fisher

    For those who don’t know the three physical join operators are Hash Match, Loop Join and Nested Loops. Understanding these …
    Continue reading

  9. Brad Shultz’s blog on reviewing your database

    1

    September 17, 2013 by Kenneth Fisher

    This is possibly the best blog I have every read on the subject of reviewing a database. It is witty, …
    Continue reading

  10. Small changes, big effects

    Leave a comment

    January 30, 2013 by Kenneth Fisher

    We got a call last week about an application that was running slowly. The server was showing about 80% CPU …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 847 other followers