Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Is the only difference between

ALTER INDEX [index_name] on [object_name] REBUILD with (ONLINE=OFF, FILLFACTOR=90)

and

DBCC DBREINDEX([dbname], 90) 

just that the DBCC command will reindex all of the indexes on all of the tables in the database?

share|improve this question
add comment

2 Answers

up vote 6 down vote accepted

The DBCC command is a consistency checker utility inside of SQL Server whereas ALTER is a DDL SQL command. The DBCC REINDEX command was deprecated in a previous version so it is not as robust as the new ALTER INDEX command is today. There is more functionality in the ALTER INDEX than the DBCC REINDEX commands:

http://msdn.microsoft.com/en-us/library/ms188388.aspx

Happy indexing!

share|improve this answer
    
I assumed as much, but just wanted to make sure. –  swasheck Jan 23 '12 at 20:54
add comment

The first is current usage, the second was deprecated in SQL 2005.

share|improve this answer
    
Thank you for your help. I assumed this was the case. –  swasheck Jan 23 '12 at 20:54
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.