Fundamentals of Query Tuning
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
Your Progress So Far in This Class
This is driven by the mark-as-complete buttons in each module of the class. (Let’s be honest: you’re probably just going to mark them as complete because you’re that kind of student. I feel you.)