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.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

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

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

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

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

share|improve this answer

Your Answer

 
discard

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