Home Forums SQL Server 2008 SQL Server 2008 Administration Just Deleting data will reclaim space?? RE: Just Deleting data will reclaim space??
arnipetursson
SSCertifiable
Points: 6557
More actions
January 16, 2013 at 9:46 am
#1577915
If the table is a HEAP only DELETE WITH (TABLOCK) or truncate are guaranteed to release space.
Best way to delete from a large table is to traverse the clustered index via a loop and delete in
chunks (a few k rows at a time).