We all have “that index script” – a DMV script we cobbled together from stuff all over. Problem is, there are huge issues with the index usage DMVs and missing index DMVs, and they don’t tell you quite what you’re expecting. Let’s do a series of demos showing the gotchas with sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats and...
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.