Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Brent Ozar
et al
in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.
Professional SQL Server 2012 Internals and Troubleshooting by Christian Bolton, Justin Langford et al
Quickly become familiar with the changes of this new release so that you can best handle database performance and troubleshooting.
Kalen Delaney MVP
Practical, hands-on guidance for SQL Server with numerous code samples, table examples, practical advice, and best practices.
Inside Microsoft SQL Server 2005: The Storage Engine by Kalen Delaney MVP
Inside Microsoft SQL Server 2005: Query Tuning and Optimization by Kalen Delaney MVP
Inside Microsoft SQL Server 2008: Internals by Kalen Delaney MVP
Beginning Transact-SQL With SQL Server 2005 by Paul Turley et al
Optimize query performance, use views and stored procedures, manage multiple databases.
SQL Cookbook by Anthony Molinaro
Each recipe demonstrates how to accomplish a given task. Perfect for quick example code to 'make it do the right thing'.