Steve Jones - SSC Editor (5/16/2011)
michael.kaufmann (5/16/2011)
I'm even more confused now ... :w00t:
The edited correct answer reads:
[...] Rows CAN span multiple pages.
[...] Ref: Pages and Extents - http://msdn.microsoft.com/en-us/library/ms190969.aspx Rows CANNOT span pages
BOL is wrong on that page. The overflow and lob data imply that the data that makes up a row can be on two different pages (or more). I think the BOL author copied from previous verisons, and despite later in the paragraph that it lists "this restriction may be relaxed", they have not corrected the initial sentence. It should read that non-variable length data types may not span across pages. So I can't have 9k worth of INT columns.
This wasn't exactly about BOL--but on the edited 'correct answer' that now bears a contradiction in it.
In my opinion the entire 'correct answer' should have been rewritten, and while the link to BOL might still have been included, the phrase rows cannot span pages should have been removed and your explanation included instead.
Thanks,
Michael