mithunbhora (3/29/2016)
... "Since we are defragmenting the same index, then why the extra space is being swallowed up by New index, although the previous one is being deleted automatically, once the newer index is created after defrag..
Defragmenting does not delete indexes and creates new ones.Index rebuilds does that.Index rebuilds moves the data to a new set of allocated pages.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server