Friday, February 22, 2013

Thoughts from Josh

NVARCHAR - to be used because if 100 characters are set aka NVARCHAR(100), but only 10 characters are used the amount of space used is 10.

WHERE if  NCHAR 100 Characters aka NCHAR(100) , but only 10 characters are used the amount of space used is 100...

Very wasteful on data storage.    "KNOW YOU YOUR DATA", as Larry Leonard would say.

No comments: