Category Archives: Performance

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

    5

    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

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

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

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

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

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

  7. Time Trial sys.dm_exec_query_plan vs sys.dm_exec_sql_text

    3

    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

Follow

Get every new post delivered to your Inbox.

Join 491 other followers