GilaMonster (1/21/2014)
LOB_DATA is your varchar(max), nvarchar(max), varbinary(max), XML and a few other data types. They have special storage.Typically you want to filter for 'in row data' when reindexing because reindexing affects only the in row data pages (reorg can compress lob data too, but that's not fragmentation in the traditional sense). If you don't, you can end up rebuilding the same index up to 3 times, which is a waste of time.
Exactly which is what I was doing! Yeah, I realize LOB_DATA is all the lob data types (I exclude those based on sys.columns); however in this particular case as shown above ... it's not using a LOB data type, so now I'm more confused.
Regardless, you're stating though to truly only focus on IN_ROW_DATA then?