Saturday, April 23, 2011

When a field is declared with nvarchar(max), is this a waste of space?

hongjun [via]
  • It is flexible length but then the field cannot be indexed.

acperkins [via]
  • In general it is considered poor practice not to define explicit sizes. You should also ask yourself if your really need to support unicode data types.

IJZ [via]
  • It will not waste the space as per varchar space allocation concept definition

No comments:

Post a Comment

Do provide your constructive comment. I appreciate that.