Sep 23 2009

Execution Plan Resources

This page contains the common list of resources from the presentations on execution plans that I’ve given. Over time I’ll get links to the sample code and slide decks from the presentations themselves.

Web Resources

SQL Server Central
Gail Shaw’s blog
Adam Machanic’s blog
Microsoft Developers Network
Ten Common SQL Programming Mistakes
Dave Ballantyne’s Exec Plan Warnings

Microsoft Whitepapers and Web Sites

Statistics used by the Query Optimizer
Compilation and Caching
Showplan Security
Understanding Joins
Analyzing a Query
Database Engine Developer InfoCenter
Database Engine Architect Info Center
Forcing Query Plans
Windows Azure SQL Database and SQL Server: Performance and Scalability Compared and Contrasted


Inside SQL Server Internals – Kalen Delaney, et al
Inside SQL Server T-SQL Querying – Itzik Ben Gan
SQL Server 2008 Transact-SQL Recipes – Joseph Sack

Slide Decks and Sample Code

Rename these files after download. None of them is a .doc file.
Fixing Execution Plans_Summit 2010
Execution Plans Deep Dive


Full Day Session:

Query Performance Tuning 2014 Code
Query Performance Tuning: Start to Finish Slides – Updated for PASS Summit 2012
Start to Finish Code


  • By faihofu, October 28, 2010 @ 12:10 pm

    RE: “Identifying and Fixing Performance Problems using Execution Plans” – webinar – EXCELLENT !!!! – thanks for taking the time to cover the topics. !

  • By Scott McLellan, October 29, 2010 @ 9:39 am

    Hi thanks again for the webinar yesterday, I’m new to execution plans and found the content very accessible and informative. Will you be posting the webinar recording at some time? Thanks!

  • By scarydba, October 29, 2010 @ 9:51 am

    Thank you. I’m glad it was helpful. I won’t be posting it, but I think PragmaticWorks will. I think this link has it:

  • By Jim Murphy, May 16, 2011 @ 6:09 am

    Grant, thanks for the precon! Well worth the money, extra night and travel. You did an absolutely fantastic job. I am blown away that this was your first pre con and I feel like I could sit there for all three days in your class. Also, I really like your scary presentation style. Tons of energy and you were very much engaged with the audience. For anyone reading who is contemplating your next precon: SIGN UP! You won’t be disappointed.

  • By Grant Fritchey, May 16, 2011 @ 7:03 am

    Thanks Jim. You were a pleasure to have there. Asked great questions at good times.

  • By Mohan Deval, November 9, 2011 @ 9:11 am

    Great Grant,
    It was just wonderful getting scared by Scary DBA but now I am blessed by your presentations, blogs, write ups & Twitter acquaintance..
    I will live w/o fear hereafter watching you present.

  • By Grant Fritchey, November 15, 2011 @ 1:47 pm

    Thanks Mohan! Yeah, I’m not nearly as scary as people say.

  • By Kevin Sexton, December 6, 2014 @ 11:17 pm

    Great demo today on execution plans. I was looking for your slide show from today on your website. (?)


  • By calin oprea, January 13, 2015 @ 2:37 am

    All the .doc resources are invalid, at least so it seems.

  • By Grant Fritchey, January 13, 2015 @ 5:57 am

    Note the comment at the top of the file listing. They are not .doc files but .zip files that need to be renamed.

  • By calin, January 13, 2015 @ 6:31 am

    Oops – skipping lines here. Thank you and apologies for this :-)

  • By Grant Fritchey, January 13, 2015 @ 6:50 am

    Not a problem. It’s a valid question. Sorry that I had to store the stuff that way.

Other Links to this Post

  1. Recap: #24hop (24hrs of PASS) – Day One | — September 16, 2010 @ 8:15 am

RSS feed for comments on this post. TrackBack URI

Leave a comment