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:

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

    Nitya

    ReplyDelete