Quick steps: Rebuilding all indexes using DBCC DBREINDEX

• Published: 22 Jan 2006

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

1. Open the Query Analyzer by selecting Query Analyzer from the Start menu.

---

2. To rebuild all indexes on the previously created IndexPractice table with a FILLFACTOR of 54, execute the following query:

   DBCC DBREINDEX (IndexPractice,' ', 54)