You can use DBCC SHRINKFILE

For more details please visit

http://msdn.microsoft.com/en-us/library/ms189493.aspx

Data types like varchar, char uses ANSI encoding technique to store character.

However to handle wide variety of languages in the world Unicode encoding mechanism had been developed. Unicode data...