Book Source Code
Presentation Slide Decks
Performance Tuning Using Execution Plans
Query Performance Tuning in SQL Server
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
Presentation Sample Code
ManageAzureWithPowerShell
ToolsForQueryTuning.zip
NonProductionEnvironments
QueryStore.zip
ParameterSniffing.zip
WhatToLookForInExecutionPlans.zip
Performance Tuning SQL Server
Performance Tuning with Execution Plans
[…] For some samples and resources used in the demo check out his resources blog page. […]
RE: “Identifying and Fixing Performance Problems using Execution Plans” – webinar – EXCELLENT !!!! – thanks for taking the time to cover the topics. !
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!
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
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.
Thanks Jim. You were a pleasure to have there. Asked great questions at good times.
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.
Thanks Mohan! Yeah, I’m not nearly as scary as people say.
Grant,
Great demo today on execution plans. I was looking for your slide show from today on your website. (?)
Thanks,
Kevin
All the .doc resources are invalid, at least so it seems.
Note the comment at the top of the file listing. They are not .doc files but .zip files that need to be renamed.
Oops – skipping lines here. Thank you and apologies for this 🙂
Not a problem. It’s a valid question. Sorry that I had to store the stuff that way.
Hi Grant, I attended Madison WI SQL Saturday this month and attended your session on Query Store in SQL Server VNext. I checked the site, your presentation is not up. Could you please point me from where I can download it? Thanks. It was very informational and I think I can use it at my work.
I have the majority of my slides on slideshare. The deck you’re looking for is here: http://www.slideshare.net/GrantFritchey/the-query-store-sql-tuning
Dear Sir,
You have share excellent information related to Query plan and Execution plan. Thanks a lot sir