This topic has been archived. It cannot be replied.
-
工作学习 / 学科技术讨论 / a SQL Server 2005 question: i have a table with 60+fields and 8 fields are nvarchar(800), will it exceed the max size of a table row? is this at any risk?
-9months(指间欢颜);
2009-7-24
(#5439775@0)
-
In SQL 2000, the row limit is 8K bytes, which is the same size as a page in memory.In 2005, the page size is the same (8K), but the database uses pointers on the row in the page to point to other pages that contain larger fields. This allows 2005 to overcome the 8K row size limitation
-deep_blue(BLUE);
2009-7-24
{202}
(#5440712@0)