Free Fundamentals of Index Tuning Week: Part 5, Recap

Whew. You’ve learned a lot. (Well, I’ve tried to teach you a lot, anyway.) Here’s what we covered this week:

Indexing for the WHERE Clause, then we covered Indexing for ORDER BY (and layering in filters as well) Indexing for JOINs SQL Server’s built-in index recommendations (Clippy)

In today’s lecture, 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 Tuning. I’ll explain what you’ll learn in each