Re: Re: Is this the answer to the Progress -v- SQL Server debate ?
by Karl Southern
The 8kb(ish) limit was a limit on the whole row before SQL 2008. From SQL 2008 the limits changed to individual fields for varchar, nchar, varbinary and sql_variant fields. The sum of the other column types in the row can still not exceed 8kb(ish) so that would include char and nchar. Good article on MSDN to explain the differences: http://msdn.microsoft.com/en-us/library/ms186981.aspx The point is well made though. Even with SQL 2008 the difference between 8Kb and 32Kb is a large one to manage.
Post comment:
Format Type: 
  Convert newlines
  Receive comment notifications for this article
Subject: 
   
insert bold tags insert italic tags insert underline tags insert strikethough tags insert link insert blockquote tags
Comment: 
Comment verification:

Please enter the text you see inside the graphic to post your comment:
You are not currently logged in. If you would like your user information to be displayed with your comment, please enter your login information below.
Login information:
Username: 
Password: 
If you would like to post contact information on your comment, please enter your information into the optional fields below:
Contact information:
Name: 
URL:  example: http://yourdomain.com
Email: 
Please note: email will not be displayed on the site, only for the blog owner. If logged in, URL will only be used.