Looking for a concise yet comprehensive overview of new T-SQL features in 2008? Itzik Ben-Gan’s white paper on TechNet is the best I’ve found yet. Check it out here: Introduction to New T-SQL Programmability Features in SQL Server 2008.
I’m particularly excited to see table-valued parameters and MERGE functionality added in 2008. 