Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to re-organize sql server 7 database?
- Thread starter mlmac
- Start date
tlbroadbent
MIS
Are you referring to the process of removing fragmentation from the database to improve performance? If yes, then you will need to do one of the following.
1) Run DBCC DBREINDEX ('tablename','',0) for each table.
See SQL BOL for more options.
2) Drop and recreate indexes. If a table has a clusered index, you only need to drop and recreate that index. SQL Server will rebuild all others.
If you have something else in mind, please provide more details.
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
1) Run DBCC DBREINDEX ('tablename','',0) for each table.
See SQL BOL for more options.
2) Drop and recreate indexes. If a table has a clusered index, you only need to drop and recreate that index. SQL Server will rebuild all others.
If you have something else in mind, please provide more details.
If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question