To rebuild a heap with lob

SQL Server Administration
1

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?

image
image927×86 8.48 KB

sql server 14.0.34.

2

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.

3

After cleantable

image
image1008×96 4.3 KB

4

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