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:
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/
Post a Comment