Thanks a lot. Certainly, I started there; however, new T-SQL features are not discussed. Just the high-level new features (the server as a whole).
Take a look at this article on Books Online: http://msdn2.microsoft.com/en-us/library/bb510411(SQL.100).aspx It includes a list of new features in each CTP, and there is a section specifically on T-SQL enhancements.
There are new data types in SQL Server 2008 http://204.9.76.233/articles/dev/datetime_2008_p1.aspx and there is MERGE command where you can have INSERT UPDATE with one statments