SQLServerCentral.com Content tagged Maintenancehttp://www.sqlservercentral.com/Content tagged Maintenance posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Check Fragmentation on All Indexes on DatabaseIn 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/The Ultimate Precompiled Procedure SearcherSearches precompiled procedures for the provided search string, optionally limiting to names matching a 2nd search string.http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/2008/06/20http://www.sqlservercentral.com/scripts/SQL+Server+2005/63508/The Ultimate Foreign Key ResearcherSearches for actual and potential foreign key columns for a given primary key reference.http://www.sqlservercentral.com/scripts/T-SQL/63509/2008/06/20http://www.sqlservercentral.com/scripts/T-SQL/63509/Move Physical Files Script to move physical files to a new locationhttp://www.sqlservercentral.com/scripts/Maintenance/62871/2008/05/30http://www.sqlservercentral.com/scripts/Maintenance/62871/SQL Server 2005 Index MaintenanceIndex maintenance procedure using rebuild or reorganized based on fragementation level.http://www.sqlservercentral.com/scripts/Maintenance/62695/2008/05/29http://www.sqlservercentral.com/scripts/Maintenance/62695/Set Database to Single user How to set the database to a single user modehttp://www.sqlservercentral.com/scripts/Maintenance/62619/2008/05/20http://www.sqlservercentral.com/scripts/Maintenance/62619/Identify Large TablesReports on physical size of tables in your database to identify largest.http://www.sqlservercentral.com/scripts/T-SQL/62053/2008/03/13http://www.sqlservercentral.com/scripts/T-SQL/62053/Script a Database RoleScript one or all roles in a database. Includes users, obect permissions and column permissions.http://www.sqlservercentral.com/scripts/SQL+2000/61878/2008/02/20http://www.sqlservercentral.com/scripts/SQL+2000/61878/Script foreign keysUsing 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/How to empty databaseSometimes you need to empty the content of database. Following script can do that for you.http://www.sqlservercentral.com/scripts/T-SQL/61312/2007/10/15http://www.sqlservercentral.com/scripts/T-SQL/61312/