I'm so glad to see that my Solid Quality Mentors colleague Itzik Ben-Gan has his T-SQL Fundamentals book now available. This book has been needed for some time. It's been updated for SQL Server 2008 and I'm sure it'll fast become one of the standard SQL Server 2008 references.
Details are here: http://www.amazon.com/Microsoft%C2%AE-Server%C2%AE-T-SQL-Fundamentals-PRO-Developer/dp/0735626014/ref=sr_1_1?ie=UTF8&s=books&qid=1225597357&sr=8-1
The companion web site for the book is here: http://www.insidetsql.com/tsqlfund2008/