SQLTeam.com | Weblogs | Forums

To rebuild a heap with lob

Hi. I have a heap with lob data (varchar(max)).
Before the rebuild, I observed only IN_ROW_DATA through sys.sys.dm_db_index_physical_stats, after the rebuild, information about LOB_DATA and ROW_OVERFLOW_DATA appeared, despite the fact that they are empty.
Is it normal? Or is there another more reliable way to return to the system the space freed after cleaning the heap?


sql server 14.0.34.

I vaguely remember DBCC CLEANTABLE might fix that, if you haven't tried it already. I can't remember exactly what it does though.

You might also want to check:

"large value types out of row" might need to be changed.

After cleantable

I wouldn't worry about it, there's only 1 page that's allocated but unused.