Category Archives: Query Plans

  1. Getting a query plan

    Leave a comment

    February 19, 2014 by Kenneth Fisher

    Query plans are an essential tool when doing performance tuning. When looking at a query plan you should be aware …
    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. Comparing an inner join vs a subquery

    11

    May 2, 2013 by Kenneth Fisher

    I was reading through Stackoverflow today and saw an interesting question. SQL inner join vs subquery. The user was comparing …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 423 other followers