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:

  1. Indexing for the WHERE Clause, then we covered
  2. Indexing for ORDER BY (and layering in filters as well)
  3. Indexing for JOINs
  4. 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 of those classes.

If you like this, you can keep the learning going with:

Folks who wanna take ’em all can get my Live Class Season Pass or a bundle of the Masters Class Recordings.

Previous Post
Free Fundamentals of Index Tuning Week: Part 4, Clippy’s Index Recommendations
Next Post
Breaking News: SQL Server 2019 CU2 Breaks Agent.

2 Comments. Leave new

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.

Menu
{"cart_token":"","hash":"","cart_data":""}