I am attempting to rebuild the indexes for a single table on a SQL Server 2005 reporting database. The indexes are heavily fragmented as this has not been done for a long time. I am running the following query...
ALTER INDEX ALL ON Table_A REBUILD
Before building the index, the data is consuming 32 GB and the indexes 98 GB. I am unable to finish the rebuild as I am running out of space once the rebuild consumes an additional 80 GB.
Is there any way to determine how much space I will need to rebuild the indexes on this table (and eventually all tables within my db)?