I ran a script which deleted a lot of rows in a table. This table contains an [IMAGE] column, which is stored in a different filegroup. After deleting these rows, I was expecting to shink the datafile with the[IMAGE] data, but it seems the deleted LOB data is not released, I cannot shrink this datafile. Note: the deleted rows were moved to a temporary table, this table was exported with BCP. The size of this BCP file indicates [IMAGE] data is included.
asked Feb 15 '11 at 07:38 AM in Default
After searching on the internet an trying the answers (REORGANIZE WITH LOB_COMPACTION or DBCC CLEANTABLE, but didn't work) it seems the only way to release this data is to drop/create the table :(
answered Feb 16 '11 at 02:42 AM
Wilfred van Dijk