Paste into SSMS and let it rip.
EXEC sp_MSforeachdb ' USE [?] SELECT object_name(object_id) as table_name ,* FROM sys.indexes WHERE fill_factor <> 0 AND fill_factor <> 100 AND is_disabled = 0 AND is_hypothetical = 0 '
An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?
2014-05-05
6,825 reads
This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.
2011-09-12
3,485 reads
This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.
2012-07-04 (first published: 2011-07-05)
19,281 reads
Reports stats on what the query optimizer records in the DMVs as missing indexes and what it says the cost savings will be if they were present. Can limit by table / schema name patterns.
2013-01-07 (first published: 2008-08-01)
21,018 reads
Gets single-column and cumulative-column selectivity stats and @Top largest dupe sets for each cumulative column stepping for a set of one or more columns for a table.
2009-05-03 (first published: 2008-08-01)
2,110 reads
