shrink table after huge delete

25112
25112 used Ask the Experts™
on
out of 10GB table, 8GB is going to be removed.
after that instead of SHRINKFILE, how can this made to release space unused.

this is a heap table.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Software & Systems Engineer
Commented:
You can rebuild the table.
ALTER TABLE NameOfTheHeapTable REBUILD

Open in new window

Jason clarkDBA Freelancer
Commented:
You could build a new database and move your data into it. This will start fresh and clean.
This is little lengthy process and more effort needed..

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial