Purge large records but cannot see free space claimed

Hi,
I purging 100 millions of records in my table, after purging completed, I did not seen my table size reduce instead it grow larger, where is my free space ? I have also run dbcc shrinkdatabase and sp_spaceused upadteusage but still I cannot reclaim the space
motioneyeAsked:
Who is Participating?
 
JoeNuvoConnect With a Mentor Commented:
try re-organize clustered index on that table.
and then shrink database, or shrink file (in filegroup assigned to that table)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.