Pages

Sunday, August 31, 2008

SQL Server Tips

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:

Anonymous said...

I must say this is very nice blog.
can u tell me where can i use NVARCHAR?

Nitya