SQLServerCentral.com Scripts tagged T-SQL Aids, Index Managementhttp://www.sqlservercentral.com/Scripts tagged T-SQL Aids, Index Management posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/Drop a Column and its Constraints and Indexeshttp://www.sqlservercentral.com/scripts/Miscellaneous/31855/2007/01/24http://www.sqlservercentral.com/scripts/Miscellaneous/31855/Updating all the indexes/statistics of a databasehttp://www.sqlservercentral.com/scripts/Index+Management/31822/2007/02/21http://www.sqlservercentral.com/scripts/Index+Management/31822/Finding missing indexes in sql server 2005http://www.sqlservercentral.com/scripts/Index+Management/31821/2007/07/19http://www.sqlservercentral.com/scripts/Index+Management/31821/Stored Proc to List Columns for a Primary Keyhttp://www.sqlservercentral.com/scripts/Miscellaneous/31794/2006/09/14http://www.sqlservercentral.com/scripts/Miscellaneous/31794/Script all indexes as CREATE INDEX statementshttp://www.sqlservercentral.com/scripts/Index+Management/31652/2006/03/17http://www.sqlservercentral.com/scripts/Index+Management/31652/Replication PreScreen for proper Primary Keyshttp://www.sqlservercentral.com/scripts/Replication/31555/2005/08/03http://www.sqlservercentral.com/scripts/Replication/31555/move all indexes to a secondary file grouphttp://www.sqlservercentral.com/scripts/Miscellaneous/31541/2006/06/19http://www.sqlservercentral.com/scripts/Miscellaneous/31541/Move a table between filegroupshttp://www.sqlservercentral.com/scripts/Miscellaneous/31526/2005/06/16http://www.sqlservercentral.com/scripts/Miscellaneous/31526/Execute SQL-DMO Database method on all databaseshttp://www.sqlservercentral.com/scripts/Miscellaneous/31481/2005/04/27http://www.sqlservercentral.com/scripts/Miscellaneous/31481/Sequential Alpha Numeric String Incrementerhttp://www.sqlservercentral.com/scripts/Miscellaneous/31448/2005/09/22http://www.sqlservercentral.com/scripts/Miscellaneous/31448/Retrieve Index Information For All Tables - V2http://www.sqlservercentral.com/scripts/Miscellaneous/31092/2004/03/04http://www.sqlservercentral.com/scripts/Miscellaneous/31092/Find Duplicate Indexeshttp://www.sqlservercentral.com/scripts/Miscellaneous/31004/2003/12/04http://www.sqlservercentral.com/scripts/Miscellaneous/31004/Function to List Primary Key Columns for a Tablehttp://www.sqlservercentral.com/scripts/Miscellaneous/30945/2003/10/24http://www.sqlservercentral.com/scripts/Miscellaneous/30945/Full server documentationhttp://www.sqlservercentral.com/scripts/Miscellaneous/30769/2003/04/28http://www.sqlservercentral.com/scripts/Miscellaneous/30769/To get Table and column name for Primary Keys.http://www.sqlservercentral.com/scripts/Miscellaneous/30755/2003/04/16http://www.sqlservercentral.com/scripts/Miscellaneous/30755/Find Duplicate Indexes (Updated)http://www.sqlservercentral.com/scripts/Miscellaneous/30701/2003/02/20http://www.sqlservercentral.com/scripts/Miscellaneous/30701/Find duplicate indexeshttp://www.sqlservercentral.com/scripts/Miscellaneous/30595/2002/11/19http://www.sqlservercentral.com/scripts/Miscellaneous/30595/For SQL 2000.Scan all indexes for fragmentationhttp://www.sqlservercentral.com/scripts/Miscellaneous/30473/2002/09/10http://www.sqlservercentral.com/scripts/Miscellaneous/30473/Show valuable info from sysindexeshttp://www.sqlservercentral.com/scripts/Miscellaneous/30466/2002/09/01http://www.sqlservercentral.com/scripts/Miscellaneous/30466/Summary of how to manage FULL TEXT indexing in TSQhttp://www.sqlservercentral.com/scripts/Index+Management/30405/2002/07/10http://www.sqlservercentral.com/scripts/Index+Management/30405/Display Row Count for all Tableshttp://www.sqlservercentral.com/scripts/Miscellaneous/30210/2002/03/12http://www.sqlservercentral.com/scripts/Miscellaneous/30210/SP to show information about log in databaseshttp://www.sqlservercentral.com/scripts/Miscellaneous/30151/2002/02/02http://www.sqlservercentral.com/scripts/Miscellaneous/30151/