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, The Team Membership, Mastering Index Tuning, Level 3 Bundle (Live Classes, Lab VM Included) or Level 2 Bundle (Live Classes, No VM Included), or log in if you already shelled out the cash.