Optimize T-SQL data types in SQL Server
December 5, 2007[From SearchSQLServer]
Many SQL Server developers do not give data types a lot of thought when they design database schemas. Initially it doesn't seem to matter much and the performance looks pretty good, but, over time, the system slows down. Let's take a look at the various SQL Server data types, the effects they have on performance, and what you should consider when choosing a data type.
The article continues at http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1284636,00.html