Mike Murach and Associates has just published a 2008 edition of their bestselling SQL book, now entitled Murachs SQL Server 2008 for Developers. It teaches how to create SQL queries and take advantage of powerful DBMS features (like views, stored procedures, functions, triggers, and cursors) the way the best professionals do.
This includes coverage of 2008 features like FILESTREAM storage, the MERGE statement, new date/time data types, the user-defined table type, the SPARSE attribute, filtered indexes, and more. But beyond that, this book has several features that make it different from most other SQL Server books.
The article continues at http://www.murach.com/books/sql8/index.htm