Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 285
  • Last Modified:

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
0
motioneye
Asked:
motioneye
1 Solution
 
JoeNuvoCommented:
try re-organize clustered index on that table.
and then shrink database, or shrink file (in filegroup assigned to that table)
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now