You’ve finished my free How to Think Like the Engine class, and now you wanna take it up a notch.
You’re confident writing queries to get the data you want, and you’ve been doing it for a couple of years. You took an intro course when you first got started, and sure, you learned select/from/where/group-by – but how do you make your queries go faster?
In this one-day course, you’ll learn:
- How sp_BlitzCache shows you which queries to focus on, and what parameters to use with sp_BlitzCache to guarantee the best bang for the buck on your own SQL Server
- How to read an execution plan to find the problems in a query
- What parts of estimated, cached, and actual plans are lying to you
- How to identify common anti-patterns in queries and plans, and fix ’em fast
Read & watch the prerequisites module before the class. I can’t emphasize enough how important that is: if you don’t fully comprehend the stuff in there, you will be terribly behind during class. During this class, you’ll frequently hear me say, “To get this part, you need to think back to ___ from How to Think Like the Engine.”
When you complete this class, you’re ready for Mastering Query Tuning.