SQL Server Reference Guide
by Buck Woody
Publisher: Pearson Education 2013
Database professional Buck Woody leads you through the many aspects of designing, administering, and developing for your SQL Server platform. Recommended for DBAs and developers alike, this Reference Guide covers SQL Server 2000 up to SQL Server 2008 R2.
Download or read it online for free here:
by Ross Mistry, Stacia Misner - Microsoft Press
This book is for anyone who has an interest in SQL Server 2008 R2 and wants to understand its capabilities. The purpose is to point out both the new and the improved in the latest version of SQL Server. Some familiarity with SQL Server is assumed.
by Jonathan Kehayias, Ted Krueger - Red gate books
SQL Server-related performance problems come up regularly and diagnosing and solving them can be difficult and time consuming. Read this book for descriptions of the most common issues and practical solutions to fix them quickly and accurately.
by Holger Schmeling - Simple-Talk Publishing
Reading Holger's booklet is a great way of brushing up on the subject of Statistics and query-optimization. It is reasonably short, and geared to the practitioner rather than the theoretician. It is careful to stick with the things you need to know.
by Benjamin Nevarez - Red gate books
A better understanding of what the Query Optimizer does behind the scenes can help you to improve the performance of your databases and applications, and this book explains the core concepts behind how the SQL Server Query Optimizer works.