Whew. You’ve learned a lot. (Well, I’ve tried to teach you a lot, anyway.) I’ll recap your most important lessons, and then give you your real-life lab: running sp_BlitzIndex in your production SQL Server and applying what you learned in class. I’ll map out your next steps, either Mastering Index Tuning or Fundamentals of Query…
Whew. You’ve learned a lot. (Well, I’ve tried to teach you a lot, anyway.) I’ll recap your most important lessons, and then give you your real-life lab: running sp_BlitzIndex in your production SQL Server and applying what you learned in class. I’ll map out your next steps, either Mastering Index Tuning or Fundamentals of Query...
To access this incredible, amazing content, you gotta get Recorded Class Season Pass or Fundamentals of Index Tuning, or log in if you already shelled out the cash.
- 0 Prerequisites Before the Class
- 1 Designing Indexes for the WHERE Clause
- 2 Lab: Indexing for WHERE
- 3 Designing Indexes for ORDER BY
- 4 Lab: Indexing for WHERE + ORDER BY
- 5 Designing Indexes for JOINs
- 6 Lab – Indexing for Joins
- 7 SQL Server’s Built-In Index Recommendations
- Bonus Lab – Getting Index Recommendations and Tuning Them