I guess this needs to be argued with Microsoft :hehe:

BOL states that "Rows cannot span pages"; if the amount of data is too large to fit into 8060 bytes, one or more variable length columns are moved to pages in the ROW_OVERFLOW_ALLOCATION unit and a pointer is kept in the original row/page.

My personal understanding and logic would say "Yes, rows can span multiple pages", but Microsoft insists on that this is not the case. Perhaps due to the different types of "normal" pages and those in the ROW_OVERFLOW_ALLOCATION unit (http://msdn.microsoft.com/en-us/library/ms189051.aspx)--but that's just my assumption.

(But then, Brandie Tarvin explicitely excluded LOB data for this response option.)

Excellent question and thorough explanation, and since I came across the above BOL page a couple of days ago, managed to get it right. 🙂

Thanks,

Michael