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

  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)
    

Click for the complete book excerpt series.

This was first published in January 2006

Dig deeper on SQL Server Database Modeling and Design

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close