Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2006-06-26 : 04:04:58
|
| Dear All,I am not cleared about DBCC CLEANTABLE after red of BOL Can Any one Explian Please..!-- KK |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-06-26 : 08:02:03
|
| You only have to use DBCC CLEANTABLE if you recently have dropped a column of variable length.DBCC CLEANTABLE reclaims space after a variable length column or a text column is dropped using the ALTER TABLE DROP COLUMN statement. It does not reclaim space after a fixed length column is dropped.DBCC CLEANTABLE runs as one or more transactions. If a batch size is not specified, the statement processes the entire row in one transaction. For some large tables, the length of the single transaction and the log space required may be too much. If a batch size is specified, the statement runs in a series of transactions, each including the specified number of rows. DBCC CLEANTABLE cannot be run as a transaction inside another transaction.Peter LarssonHelsingborg, Sweden |
 |
|
|
CSK
Constraint Violating Yak Guru
489 Posts |
Posted - 2006-06-26 : 23:43:26
|
quote:
Originally posted by Peso
You only have to use DBCC CLEANTABLE if you recently have dropped a column of variable length.DBCC CLEANTABLE reclaims space after a variable length column or a text column is dropped using the ALTER TABLE DROP COLUMN statement. It does not reclaim space after a fixed length column is dropped.DBCC CLEANTABLE runs as one or more transactions. If a batch size is not specified, the statement processes the entire row in one transaction. For some large tables, the length of the single transaction and the log space required may be too much. If a batch size is specified, the statement runs in a series of transactions, each including the specified number of rows. DBCC CLEANTABLE cannot be run as a transaction inside another transaction.Peter LarssonHelsingborg, Sweden
Thanks Peter Larsson |
|
|
|
|
|
|
DBCC CLEANTABLE