Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)

Microsoft SQL Server(TM) 2005 Analysis Services Step by Step (Step by Step (Microsoft))

Professional SQL Server 2005 Integration Services (Programmer to Programmer)

Microsoft SQL Server(TM) 2005 Administrator's Pocket Consultant (Pro-Administrator's Pocket Consultant)

Databases

Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer)

Format: Paperback
Author: Itzik Ben-gan
ReleaseDate: 14 June, 2006
Publisher: Microsoft Press
Rating:

Serious SQL Programmers need this book
If you're new then look at T-SQL Querying. Firstly, this is not a book for beginners or those new to T-SQL, this is targetted more towards intermediate/advanced programmers.
The level of knowledge and detail that Itzik, Dejan and Roger have and portray in this book is awesome. Do you want to know how SQL Server 2005 internally stores date/time values and what the pitfalls are that you might run into when programming against date/time values (one of the most common problems facing SQL programmers), this book has the answer.
With chapters on Stores Procedures, Transactions, temporary tables, views, the service broker and more.
Each chapter has excellent advice and knowledge and filled with sample code (available online). The book is targetted specifically at SQL Server 2005 and the new ways it handles things, new functions and commands.
My only concern and a slight one at that is that with the amount of information the authors are trying to portray in 500 pages, sometimes the reading is heavy.
An invaluable book for SQL Server 2005 programmers.