• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 590
  • Last Modified:

DBCC Cleantable not reclaimimn space


I have a table which sp_spaceused tells me has a gig of unused space.  I'd like to reorganize the table to reclaim the space.  I did a dbcc cleantable('db', 'table').   After minutes of work, the dbcc ended reporting success.  But, sp_spaceused still tells me the dbcc had no effect.  The unused space is still unclaimed.

Can any one tell me how to get this table to give up it's unused space?

1 Solution
Anthony PerkinsCommented:
>>Can any one tell me how to get this table to give up it's unused space?<<
Unless space is a premium, in general it is not recommended to do this.  However, if you insist take a look at the DBCC SHRINKDATABASE and DBCC SHRINKFILE functions in Books Online.
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.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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