SQL Server Gems

Friday, February 24, 2006

Page Size Limit

In SQL Server 7.0 and 2000, the page size limit was 8K (i.e. 8060) bytes.

One of the gems in SQL Server 2005 is that it now allows rows to span multiple pages, which means users can now have rows that exceeds the 8060 byte limit of its predecessors.

0 Comments:

Post a Comment

<< Home