Jun 24, 2016
Find Unused Indexes in SQL Server
Find Unused Indexes in SQL Server
Every SQL Server Database Administrator must monitor database performance and add or remove indexes as required. In this article by Sudarshan Narasimhan we see a couple of scripts on the subject.
Identifying Unused Indexes
USE [DBNAME] /* Replace with your Database Name */ GO --TOTALLY UN-USED INDEXES SELECT DB_NAME(s.database_id) as [DB Name], OBJECT_NAME(s.[object_id]) AS [Table Name], i.name…
View On WordPress