SQL Converting NChar to NVarChar

While designing a database using MSSQL, I inadvertantly left some fields using the default NChar data type. The downside to using this data type, is that you specify the max number of characters for that field and when you put text into it, it pads it with spaces.  This means more data coming back with SQL queries and also means […]