Category Archives: Performance

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

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

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

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

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

  6. 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 173 other followers