Don't use the NVARCHAR or NCHAR data types unless you need to store 16-bit character (Unicode) data. They take up twice as much space as VARCHAR or CHAR data types, increasing server I/O and wasting unnecessary space in your buffer cache.
A place to learn from Little Techie... Little Techie who is Microsoft Most Valuable Professional (MVP), Most Valuable Contributor (MVC), Most Valuable Member (MVM), Member of the Year..........
Don't use the NVARCHAR or NCHAR data types unless you need to store 16-bit character (Unicode) data. They take up twice as much space as VARCHAR or CHAR data types, increasing server I/O and wasting unnecessary space in your buffer cache.
1 comment:
I must say this is very nice blog.
can u tell me where can i use NVARCHAR?
Nitya
Post a Comment