Wednesday, May 26, 2010

SQL 2008 : Row-Overflow Data Exceeding 8 KB

Prior to SQL 2008 tables where a single row exceeds a PAGE (8K) needed rethinking.

From MSDN >

" A table can contain a maximum of 8,060 bytes per row. In SQL Server 2008, this restriction is relaxed for tables that contain varchar, nvarchar, varbinary, sql_variant, or CLR user-defined type columns. The length of each one of these columns must still fall within the limit of 8,000 bytes; however, their combined widths can exceed the 8,060-byte limit. This applies to varchar, nvarchar, varbinary, sql_variant, or CLR user-defined type columns when they are created and modified, and also to when data is updated or inserted."

MSDN : Row-Overflow Data Exceeding 8 KB

Solace : Maximum row size

1 comment:

Anvesh Patel said...

Nice Article !

Really this will help to people of SQL Server Community.
I have also prepared small note on this, What happend when row overflow and data exceeding 8KB size in SQL Server.

http://www.dbrnd.com/2016/04/sql-server-what-happened-when-row-overflow-and-data-exceeding-8kb/