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

Books

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.

ParameterSniffing.zip
WhatToLookForInExecutionPlans.zip
TopTipsForBetterTSQL.zip

BestPracticesWorkingWithExecutionPlans.zip
ScoutingOutExecutionPlans.zip
MUQt.zip
IdentifyingCostlyQueries.zip
Fixing Execution Plans_Summit 2010
Optimizer
Execution Plans Deep Dive

QueryTuningAzureSQLDatabase

Full Day Session:
Query Performance Tuning: Start to Finish Slides – Updated for PASS Summit 2012
Start to Finish Code

8 Comments

  • 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: http://cms.pragmaticworks.com/Videos/Default.aspx?VidID=a514b4171ac14de79c8dcece3a657f15&app

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

Other Links to this Post

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

RSS feed for comments on this post. TrackBack URI

Leave a comment