1.6 Lab 2 Setup: Tuning Indexes for Specific Queries

Now let’s take the reverse problem: let’s start with nothing. We’ll drop all of the nonclustered indexes in our Stack Overflow database, then run the demo workload again. This time, we’re going to use sp_BlitzCache to list the most resource-intensive queries, look at Clippy’s index recommendations for them, and hand-craft our own indexes instead. Then,…

To access this incredible, amazing content, you gotta get Live Class Season Pass, Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.

Now let’s take the reverse problem: let’s start with nothing. We’ll drop all of the nonclustered indexes in our Stack Overflow database, then run the demo workload again. This time, we’re going to use sp_BlitzCache to list the most resource-intensive queries, look at Clippy’s index recommendations for them, and hand-craft our own indexes instead. Then,...
To access this incredible, amazing content, you gotta get Live Class Season Pass, Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.
Menu