Skip to main content

Posts

Showing posts from December, 2021

SQL Server - Query for Possible bad Indexes

 --Possible bad Indexes (writes > reads) SELECT  OBJECT_NAME(s.object_id) AS 'Table Name',sca.name  , i.name AS 'Index Name', 'DROP INDEX ' + i.name + ' ON ' + sca.name + '.' + OBJECT_NAME(s.object_id)  ,         i.index_id, user_updates AS 'Total Writes',         user_seeks + user_scans + user_lookups AS 'Total Reads',         user_updates - ( user_seeks + user_scans + user_lookups ) AS 'Difference' FROM    sys.dm_db_index_usage_stats AS s WITH ( NOLOCK )         INNER JOIN sys.indexes AS i WITH ( NOLOCK ) ON s.object_id = i.object_id                                                        AND i.index_id = s.index_id INNER JOIN sys.tables AS t ON s.object_id = t.object_id INNER JOIN sys.schemas As sca on t.schema_id = sca.schema_...