September 11, 2008 at 1:49 pm
We archived roughly 12million out of 16 million rows of text in our DB. More or less setting the text fields to say "Archived". When I analyze the dm_db_index_physical_stats against this table, the LOB_DATA is around 147GB. I've reorganized the index, run DBCC CLEANTABLE, and still nothing.
So the LOB_DATA appears to be hanging out in the file structure, and doesn't want to be reduced. I understand that this is the case when you alter Text fields (as we did), but I thought that reorganizing indexes and DBCC CLEANTABLE was supposed to fix this.
Any ideas anyone?
December 15, 2010 at 1:51 am
Do you happen to have "read_committed_snapshot"=ON for the database in question.
I have something of the same problem (I delete records though) and cannot get rid of the blob data.
If i change the read_committed_snapshot to OFF the problem disappears
Best regards
/Jesper
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply