We can use dynamic management view “sys.dm_db_index_usage_stats” to identify unused indexes on SQL Server.
This DMV shows you how many times the index was used for user queries. 294 more words
3 weeks, 3 days
Journey to SQL Authority with Pinal Dave
If you ever thought this is some sort of trick to bring you to the blog, well you are wrong. This infact is something worth a look and interesting thing to know. 803 more words
1 month, 1 week