2

does DBCC ShrinkDatabase doa Reorganize of files?

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

2 Answers 2

2

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.

1
0

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.