question

David 2 1 avatar image
David 2 1 asked

After Shrinking A Datafile Why Does Index Rebuild Reclaim Back the Shrunk Capacity But Index Reorganization Does Not?

Hi there,

I recently performed a DBCC SHRINKFILE to shrink down the unused space from a datafile. Immediately afterwards I did an INDEX REBUILD to defrag all the fragmentation caused by the shrink command. Afterwards I noticed that the datafile had been enlarged back to it's original size. When I re-completed the same task of doing another DBCC SHRINKFILE but this time I used INDEX REORGANIZATION the fragmentation was removed and the datafile did not enlarge back to it's original size. Why?

TIA

indexesdbccrebuildshrinkreorganize
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.