Quick steps: Rebuilding all indexes using DBCC DBREINDEX
Learn how to rebuild indexes in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation.
The following excerpt, courtesy of Que Certification, is from Chapter 10 of the book MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation by Thomas Moore and Ed Tittel. Click for the complete book excerpt series or purchase the book.
STEP BY STEP - 10.5
Rebuilding all indexes using DBCC DBREINDEX
- Open the Query Analyzer by selecting Query Analyzer from the Start menu.
- To rebuild all indexes on the previously created IndexPractice table with a FILLFACTOR of 54, execute the following query:
DBCC DBREINDEX (IndexPractice,' ', 54)
Click for the complete book excerpt series.