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.

does DBCC ShrinkDatabase doa Reorganize of files?

Basically does it mimic the same process as if i checked Reorganize in the GUI?

share|improve this question
add comment

migrated from stackoverflow.com Jan 21 '12 at 16:47

This question came from our site for professional and enthusiast programmers.

2 Answers

up vote 2 down vote accepted

No, actually it is notoriously bad for fragmenting the data. You should do a re-org after the shrink is complete.

FROM MSDN:

A shrink operation does not preserve the fragmentation state of indexes in the database, and generally increases fragmentation to a degree. This is another reason not to repeatedly shrink the database.

share|improve this answer
    
+1 sqlskills.com/blogs/paul/post/… –  Remus Rusanu Apr 26 '11 at 19:17
add comment

No overlap except in some rare cases where you have heaps (tables without clustered indexes)

share|improve this answer
add comment

Your Answer

 
discard

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