Login | Register   
LinkedIn
Google+
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Advanced
Aug 17, 2004

Use DBCC CLEANTABLE to Reclaim Unused Space in Your SQL Server Tables

This is a great tip for DBAs. If you ever end up removing a variable-length column (varchar) or text column from one of your tables, a certain amount of wasted space will linger in the table's physical representation. You can reclaim this space with the DBCC CLEANTABLE statement.

To use DBCC CLEANTABLE, pass two required parameters and an optional batch size as a third. The first parameter is the database name (character data), or database id (integer data). The second is the table, or view name or id (again, character and integer data, respectively). If you specify a batch size, the reclamation job is carried out in multiple steps, each equal to the batch size you provided; otherwise, the entire job is attempted in a single step. This may occasionally present timeout or log space challenges, requiring the batch approach.

**Note: This technique doesn't work when you remove a fixed-length column.

Parthasarathy Mandayam
 
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date