In this one-day course, you’ll learn:
- How to design indexes for a query without looking at its execution plan
- How to pick the order of keys in an index
- How query parameter values can change which index is better
- Where to find index recommendations using query plans, DMVs, and sp_BlitzIndex
- How SQL Server’s index recommendations are built, and why they’re often wrong
Note: this course does not cover columnstore, In-Memory OLTP, XML, or spatial indexes. (Nothing against those – they’re just beyond fundamentals.)
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.”
If you want to test yourself with the exercises during class, get SQL Server 2008 or newer, and download the Stack Overflow 2010 database (small, 10GB.) The lab exercises will work on any 2008+ version of SQL Server. I use 2019 during the class, but you totally don’t have to – I won’t be covering cutting edge stuff in here, just fundamentals that everyone can use right away on any version/edition.
After this class, you’re ready for Mastering Index Tuning.