Row size – 8060 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Row size – 8060

is there any way around this? why is this a limit?
It’s a limit becoz each row has to fit on a page. 1 data page =8k. Nope, no way round it.. except – normalize – use text columns Tom Pullen
DBA, Oxfam GB
so text columns in a table do not count towards the 8060 row size limit?
What do you need the row to be bigger than that for? Is it one particular column, or several columns added together? MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
nothing specific here. so text columns in a table do not count towards the 8060 row size limit?
No – text columns are stored separately and don’t count towards the limit. text data can be vast. However it requires special (different) coding for updating, using TEXTPTR, etc.. Tom Pullen
DBA, Oxfam GB
Any number of image or text columns per row, only 16-byte pointer stored with row, data stored on other data pages. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
is the same row size limit in SQL Server 2005?
YEs I presuem, excerpts from SQL2K5 BOL:
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.] In a table, the maximum number of bytes per row is 8,060 bytes. In Microsoft® SQL Server™ 2005 Beta 2, this restriction is relaxed for tables containing varchar, nvarchar, varbinary, or sql_variant 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 row limit in a table. This applies to varchar, nvarchar, varbinary, or sql_variant columns when they are created and altered, as well as to when data is updated or inserted.
Note:
This restriction does not apply to varchar(max), nvarchar(max) or varbinary(max) columns. For more information about the storage of these columns, see Using Large Value Data Types.
 Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>