>>Yes, for big character fields you may want to use Varchar fields as they take less space.
>
>What defines a big character field? Is it 10, 20 or more characters?
>
>>There is a great article http://aboutsqlserver.com/2010/08/11/how-sql-server-stores-data-extents-data-pages-data-row-for-in-row-data/ explaining the innards of SQL Server.
>
>Thanks for the reference

5 characters and more it will make sense to use varchar field.