2.3 Lab 3 Setup: Tuning Indexes for Specific Queries
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, we’ll run the demo workload again, and see if our […]
To access this incredible, amazing content, you gotta get Mastering Index Tuning or Recorded Class Season Pass, or log in if you already shelled out the cash.