The article is pretty sweet, I'd just like to mention an error on the part refering to SMALLDATETIME... this data type does not discard time data; it's just more imprecise and covers a smaller date range:

http://msdn.microsoft.com/en-us/library/ms187819(v=SQL.90).aspx