Category Archives: Query Plans

  1. Comparing two query plans

    3

    June 14, 2016 by Kenneth Fisher

    This month my friend Michael J Swart(b/t) would like us to talk about the new 2016 version of SQL Server. …
    Continue reading

  2. Using LEN wrong.

    4

    June 2, 2016 by Kenneth Fisher

    I was reading someone’s question the other day on StackExchange and while the existing comments/questions solved the OP’s (original poster) …
    Continue reading

  3. Getting a query plan

    1

    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

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

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

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

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

Join 1,569 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013