• Not absolutely, but the best chance is to specify "SORT_IN_TEMPDB = ON" when you rebuild the index for compression. That will SQL will use tempdb for the work space instead of the main db.

    Btw, you can't compress a heap, so I assume you meant it was a heap before you created a compressed clustered index to cause the table to compress.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.