http://www.sqlservercentral.com/Content tagged Administration, Index Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Checks index usagehttp://www.sqlservercentral.com/scripts/Administration/63167/2008/06/24http://www.sqlservercentral.com/scripts/Administration/63167/Solution for Backup, Integrity Check and Index Optimization in SQL Server 2005.http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/2008/04/15http://www.sqlservercentral.com/scripts/Backup+%2f+Restore/62380/Shows unused indexes compared to nr of modificationshttp://www.sqlservercentral.com/scripts/Administration/61330/2007/12/18http://www.sqlservercentral.com/scripts/Administration/61330/Examining statistics of indexes is useful for optimizing the performance of queries. Statistics help us determine the usage and worth of indexes - one simple method is using the index-related dynamic management view; sys.dm_db_index_usage_statshttp://www.sqlservercentral.com/redirect/articles/61421/2007/11/12http://www.sqlservercentral.com/redirect/articles/61421/