Geeks With Blogs
BizTalk Blog by Chris Han System Design for Enterprise Agility,
February 2007 Entries
New 'Row-Overflow' feature and the impact to database design in SQL 2005
SQL 2K5 introduces a new behavior row-overflow, which enable the combined row size exceed 8,060 bytes per row limit for varchar, nvarchar, varbinary, sql_variant or CLR user-defined type columns. For more details, check out BOL: What's this mean to the database professionals? Good news for data modelers is you don't have to worry about the error message 'Cannot create a row of size xxxx which is greater than the allowable maximum of 8060' when ......

Posted On Tuesday, February 27, 2007 10:18 AM

Copyright © Chris Han | Powered by: