SQLServerCentral.com Scripts tagged Maintenance and Management, Index Managementhttp://www.sqlservercentral.com/Scripts tagged Maintenance and Management, Index Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)SQL Server 2005 - Backup, Integrity Check and Index OptimizationSolution 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/Get all user def table info with rowcount and sizehttp://www.sqlservercentral.com/scripts/Miscellaneous/31992/2007/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/31992/SQL Server 2005: Script all Indexeshttp://www.sqlservercentral.com/scripts/Miscellaneous/31893/2007/03/27http://www.sqlservercentral.com/scripts/Miscellaneous/31893/SQL Server 2005: Script all Primary Keyshttp://www.sqlservercentral.com/scripts/Index+Management/31892/2007/03/28http://www.sqlservercentral.com/scripts/Index+Management/31892/Drop a Column and its Constraints and Indexeshttp://www.sqlservercentral.com/scripts/Miscellaneous/31855/2007/01/24http://www.sqlservercentral.com/scripts/Miscellaneous/31855/Find possible missing foreign key relationshipshttp://www.sqlservercentral.com/scripts/Miscellaneous/31835/2007/02/26http://www.sqlservercentral.com/scripts/Miscellaneous/31835/Remove index fragmentationhttp://www.sqlservercentral.com/scripts/Index+Management/31824/2007/07/20http://www.sqlservercentral.com/scripts/Index+Management/31824/Update statistics for all tables in any DBhttp://www.sqlservercentral.com/scripts/Index+Management/31823/2006/12/22http://www.sqlservercentral.com/scripts/Index+Management/31823/Get All Foreign Key names and Tables referencedhttp://www.sqlservercentral.com/scripts/Index+Management/31807/2007/07/09http://www.sqlservercentral.com/scripts/Index+Management/31807/List all indexes with keys, description and size http://www.sqlservercentral.com/scripts/Index+Management/31800/2007/07/03http://www.sqlservercentral.com/scripts/Index+Management/31800/Stored Proc to List Columns for a Primary Keyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31794/2006/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/31794/Function to return the SQL Version Numberhttp://www.sqlservercentral.com/scripts/Replication/31754/2006/08/08http://www.sqlservercentral.com/scripts/Replication/31754/Function to return the SQL Build Numberhttp://www.sqlservercentral.com/scripts/Replication/31753/2006/08/09http://www.sqlservercentral.com/scripts/Replication/31753/Improved Move indexes to new file grouphttp://www.sqlservercentral.com/scripts/Miscellaneous/31649/2006/03/22http://www.sqlservercentral.com/scripts/Miscellaneous/31649/List index information for all databaseshttp://www.sqlservercentral.com/scripts/Index+Management/31591/2006/10/30http://www.sqlservercentral.com/scripts/Index+Management/31591/List index information for the current databasehttp://www.sqlservercentral.com/scripts/Index+Management/31590/2005/10/18http://www.sqlservercentral.com/scripts/Index+Management/31590/Replication PreScreen for proper Primary Keyshttp://www.sqlservercentral.com/scripts/Replication/31555/2005/08/03http://www.sqlservercentral.com/scripts/Replication/31555/Generate Quick Snapshot of table structures.http://www.sqlservercentral.com/scripts/Miscellaneous/31546/2005/07/28http://www.sqlservercentral.com/scripts/Miscellaneous/31546/Move a table between filegroupshttp://www.sqlservercentral.com/scripts/Miscellaneous/31526/2005/06/16http://www.sqlservercentral.com/scripts/Miscellaneous/31526/Display Table and Index Space Allocationhttp://www.sqlservercentral.com/scripts/Miscellaneous/31524/2005/06/13http://www.sqlservercentral.com/scripts/Miscellaneous/31524/usp_get_all_stats_datehttp://www.sqlservercentral.com/scripts/Miscellaneous/31491/2006/07/17http://www.sqlservercentral.com/scripts/Miscellaneous/31491/Execute SQL-DMO Database method on all databaseshttp://www.sqlservercentral.com/scripts/Miscellaneous/31481/2005/04/27http://www.sqlservercentral.com/scripts/Miscellaneous/31481/Retrieve Index Information For All Tables - V2http://www.sqlservercentral.com/scripts/Miscellaneous/31092/2004/03/04http://www.sqlservercentral.com/scripts/Miscellaneous/31092/Retrieve Index Information For All Tableshttp://www.sqlservercentral.com/scripts/Miscellaneous/31082/2004/03/01http://www.sqlservercentral.com/scripts/Miscellaneous/31082/Generate Index for Foreign Keyshttp://www.sqlservercentral.com/scripts/Index+Management/31079/2006/07/12http://www.sqlservercentral.com/scripts/Index+Management/31079/Display Defragmentation Of Selected Tableshttp://www.sqlservercentral.com/scripts/Miscellaneous/30904/2003/08/21http://www.sqlservercentral.com/scripts/Miscellaneous/30904/Database data dictionaryhttp://www.sqlservercentral.com/scripts/Miscellaneous/30895/2003/08/14http://www.sqlservercentral.com/scripts/Miscellaneous/30895/Find Duplicate Indexes - Episode 1 (The Early SQL Versions)http://www.sqlservercentral.com/scripts/Index+Management/30816/2003/05/28http://www.sqlservercentral.com/scripts/Index+Management/30816/Rebuild indexes, update stats and shrinkhttp://www.sqlservercentral.com/scripts/Index+Management/30797/2003/05/07http://www.sqlservercentral.com/scripts/Index+Management/30797/Full server documentationhttp://www.sqlservercentral.com/scripts/Miscellaneous/30769/2003/04/28http://www.sqlservercentral.com/scripts/Miscellaneous/30769/