SQL Data Page Storage
Posted on 2011-09-15
Reading through a book (SQL 2008) to increase my SQL knowledge in hopes of moving towards a DBA role and had a question. The book states "Data pages contain data rows from tables. These rows cannot span pages. Because of the page header and row offset information, the maximum row size is limited to 8,060 bytes."
Is the row they are refering to an entire row in a table because it seems like a single row could easily be larger than 8060 bytes? Or can a Data Page row be just a single column value with a table row spanning mutliple Data Pages? If not what happens when a table row is larger than 8,060 bytes?