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 ...
read more