After running a real-world-style workload against the Stack Overflow database, you’ll recover from the aftermath by analyzing the index DMVs. You can use sp_BlitzIndex or your weapon of choice, and figure out how to get each table down to as few indexes as practical. Here’s the format that I want to see your homework in:...
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.