Wednesday, May 7, 2014

If you spill over 8000 characters in an nvarchar(max) field...

...the additional data will be kept out of row data elsewhere creating a performance hit for looking it up. What gets stuffed into an nvarchar(max) field may be up to two gigs.

No comments:

Post a Comment