After deletes and updates have left empty space on pages or have left empty pages on extents, use one of the following techniques to reclaim space in heap tables:
Use the reorg rebuild command (data-only-locked tables only).
Create and then drop a clustered index.
Use bcp (the bulk copy utility) and truncate table.
