anthony.green (12/18/2012)
Strange on seeing the row_overflow as that should kick in when the row spans more than 8060 bytes, but the maximum row length is only 6148 bytes so strange on that one.The lob data is expected as it will have farmed the XML columns off to the LOB store tree so will need to be able to use the pointers back to the clustered index.
Could the Page fill factor be an issue here? where by the Rebuild has used a lower fill factor than when the table was originally built? though in the Alter Index I cant see anything that suggests this is the case.
_________________________________________________________________________
SSC Guide to Posting and Best Practices