SQL Scripts for Microsoft SQL Server and SSE Databases

starteam_sqlserver_dbcc.sql

Run: weekly.

This script rebuilds the database indexes and performs a consistency check on the database objects. This script builds the indexes and updates the statistics in the database distribution pages.

starteam_sqlserver_dbcc_reindex.sql

Run: at least twice a week.

This script rebuilds all the indexes in the database. It is extremely important to run this script routinely.

starteam_sqlserver_dbcc_showcontig.sql

Run: at least twice a week.

This script gives information on database fragmentation.

starteam_sqlserver_dropall.sql

Run: only if necessary.

CAUTION:

Running this script deletes all Atlas Hub tables and the data they contain from the database. Use this script with extreme caution.

One use case example is if you migrate an Atlas Hub configuration to another database, you might use this script to remove tables from the original database. Another example is if you mistakenly add the Atlas Hub tables to a tablespace other than the Atlas Hub tablespace, use this script to remove them.