LOB Columns & sys.partitions
On the table and index organization page in the sql server documentation link here, under the Allocation Units section, the documentation states:
Each table that has at least one LOB column also has a row in sys.partitions with index_id > 250.
Whilst looking for sparsely populated image columns in one of my tables that’s taking up waay too much room I noticed that said table does indeed contain a LOB column (image data type), yet has no index listed in sys.partitions with an index_id > 250.
Here is the results from querying the sys.partitions table:
Here’s the allocations from the sys.system_internals_allocation_units table. Obviously a bunch of unused space in this table.
Is the documentation wrong? Why you sys.partitions no have index_id > 250 for image column?