Thanks for clearing it up Lowell. That makes (some) sense

Could you tell me what is conceptually the difference between DATA LENGTH (in bytes) and amount of bytes allocated to memory...

Hey Lowell,

Thanks for your reply. Im confused because the same exercise of an nvarchar or nchar string gives DataLength of 10 - i thought a similar overhead on varchar would...