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.