http://www.sqlservercentral.com/Content tagged Index Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)In this script we create a temporal table and then review all indexes with next conditions. avg_fragmentation_in_percent > 10 % or avg_page_space_used_in_percent > 90 % http://www.sqlservercentral.com/scripts/Index+Management/63649/2008/07/10http://www.sqlservercentral.com/scripts/Index+Management/63649/Checks index usagehttp://www.sqlservercentral.com/scripts/Administration/63167/2008/06/24http://www.sqlservercentral.com/scripts/Administration/63167/Manual SP to Index Defrag a SQL 2000 database on SQL 2005 that run at spesific times at nighthttp://www.sqlservercentral.com/scripts/Indexing/63036/2008/06/19http://www.sqlservercentral.com/scripts/Indexing/63036/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/Script find all foreign key without index in database and create new one for them.http://www.sqlservercentral.com/scripts/Index+Management/62069/2008/03/04http://www.sqlservercentral.com/scripts/Index+Management/62069/Better script for determining unused indexeshttp://www.sqlservercentral.com/scripts/Tuning/61886/2008/02/21http://www.sqlservercentral.com/scripts/Tuning/61886/Using this script you can create a list of sql commands for foreign keys manipulation.http://www.sqlservercentral.com/scripts/T-SQL/61463/2008/01/08http://www.sqlservercentral.com/scripts/T-SQL/61463/Shows unused indexes compared to nr of modificationshttp://www.sqlservercentral.com/scripts/Administration/61330/2007/12/18http://www.sqlservercentral.com/scripts/Administration/61330/(SQL 2005) Creates Index Creation statements based on info colected in system view sys.dm_db_missing_index_details, either with included columns or just In(Equality) columns.http://www.sqlservercentral.com/scripts/SQL+Server+2005/61298/2007/12/13http://www.sqlservercentral.com/scripts/SQL+Server+2005/61298/Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information.http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/2007/12/11http://www.sqlservercentral.com/scripts/SQL+Server+2005/61278/http://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/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/Paul Randal, former SQL Server Storage Engine lead, brings us a great explanation of how indexes are affected when you alter your schema.http://www.sqlservercentral.com/redirect/articles/61371/2007/10/31http://www.sqlservercentral.com/redirect/articles/61371/http://www.sqlservercentral.com/scripts/Index+Management/31980/2007/10/25http://www.sqlservercentral.com/scripts/Index+Management/31980/http://www.sqlservercentral.com/scripts/Index+Management/31986/2007/08/17http://www.sqlservercentral.com/scripts/Index+Management/31986/http://www.sqlservercentral.com/scripts/Index+Management/31985/2007/08/17http://www.sqlservercentral.com/scripts/Index+Management/31985/http://www.sqlservercentral.com/scripts/Index+Management/31824/2007/07/20http://www.sqlservercentral.com/scripts/Index+Management/31824/http://www.sqlservercentral.com/scripts/Index+Management/31821/2007/07/19http://www.sqlservercentral.com/scripts/Index+Management/31821/http://www.sqlservercentral.com/scripts/Index+Management/31810/2007/07/11http://www.sqlservercentral.com/scripts/Index+Management/31810/http://www.sqlservercentral.com/scripts/Index+Management/31807/2007/07/09http://www.sqlservercentral.com/scripts/Index+Management/31807/http://www.sqlservercentral.com/scripts/Index+Management/31800/2007/07/03http://www.sqlservercentral.com/scripts/Index+Management/31800/http://www.sqlservercentral.com/scripts/Index+Management/31908/2007/04/30http://www.sqlservercentral.com/scripts/Index+Management/31908/Check Indexes on all databases and rebuild/reindex based on fragmentationhttp://www.sqlservercentral.com/scripts/Index+Management/31911/2007/04/25http://www.sqlservercentral.com/scripts/Index+Management/31911/http://www.sqlservercentral.com/scripts/Index+Management/31883/2007/04/09http://www.sqlservercentral.com/scripts/Index+Management/31883/http://www.sqlservercentral.com/scripts/Index+Management/31892/2007/03/28http://www.sqlservercentral.com/scripts/Index+Management/31892/http://www.sqlservercentral.com/scripts/Miscellaneous/31893/2007/03/27http://www.sqlservercentral.com/scripts/Miscellaneous/31893/http://www.sqlservercentral.com/scripts/Index+Management/31883/2007/04/09http://www.sqlservercentral.com/scripts/Index+Management/31883/http://www.sqlservercentral.com/scripts/Index+Management/31883/2007/04/09http://www.sqlservercentral.com/scripts/Index+Management/31883/http://www.sqlservercentral.com/scripts/Miscellaneous/31835/2007/02/26http://www.sqlservercentral.com/scripts/Miscellaneous/31835/http://www.sqlservercentral.com/scripts/Index+Management/31822/2007/02/21http://www.sqlservercentral.com/scripts/Index+Management/31822/