SQL Server 2008 data types: which ones should i use?

Question

I am trying to figure out which data types I should use for my tables. Does someone have a very good, simple, tutorial on SQL Server 2008 datatypes (has to be practical!) ?

Answer 1

Here is a nice post.

Answer 2

http://www.databasejournal.com/features/mssql/article.php/3788256/Data-Types-in-SQL-Server-2008.htm
http://searchsqlserver.techtarget.com/feature/SQL-Server-2008-data-types-Datetime-string-user-defined-and-more
The first link is more practical. As far as I know, SQL Server 2005 and 2008 almost have the same data types. (except new DateTime data type).

Answer 3

I think the best way of choosing the type is self knowledge about project mixed with the knowledge of available types that why i advise You to get familiar with Data types in MS-SQL and generally with MSDN