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:48 am
#1577918
If you are going to shrink the data file(s), you should leave enough space to rebuild the clustered indexes of your largest table.
After shrink you must rebuild all clustered indexes.