How SQL Server 2005 stores nvarchar(n)?

If we take nvarchar(3000) for a column, server does not allocate 3000 character at the initial.
It means if we write 200 characters into that column it will allocate 200 only not 3000.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.