David.Poole (5/26/2010)
Paul White NZ (5/26/2010)
This is not so.Rebuilding the clustered index does indeed reclaim the space.
What am I doing wrong Paul? I don't seem to get any space back (in SQL2005) other than that I would get by defragging the index.
depends on the size of the table, data and the amount of fragmentation
i've rebuilt indexes manually on a table with 200-300 million rows and i've seen space reclaimed with each index rebuilt