SQL Server Index Tuning with DMVs: sys.dm_db_index_usage_stats, Missing Index Details, and Operational Stats

Using SQL Server DMVs to tune your indexing strategy - identifying unused indexes (sys.dm_db_index_usage_stats), finding operational hotspots including latching and...