Index Usage Stats Insanity - the oddities of sys.dm db index usage stats (Dear SQL DBA)
Category:
indexing
SQL Server’s “index usage stats” dynamic management view is incredibly useful– but does it tell you what you THINK it tells you?
I explain the quirks of how sys.dm_db_index_usage_stats works and why the information is so valuable.