Answer by Scot Hauder ·
Answer by ozamora ·
Answer by Wilfred van Dijk ·
select sa.*, sp.*, object_name(sp.object_id) from sys.allocation_units sa join sys.partitions sp on sa.container_id = sp.hobt_id where sa.data_space_id = 1 order by sa.total_pages descit seems to be LOB_DATA.