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 StarTeam Server tables and the data they contain from the database. Use this script with extreme caution.

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