Tag Archives: Performance

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

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

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

  4. Two simple commands that can be a big help in performance tuning.

    8

    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

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

  6. A better way to find missing indexes

    12

    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

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

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

  9. Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text

    4

    November 12, 2012 by Kenneth Fisher

    I’ve been working on a way to test performance usage on a server by database. I started out using sys.dm_exec_query_stats …
    Continue reading

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

Join 2,542 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013