Troubleshooting SQL Server: A Guide for the Accidental DBA
by Jonathan Kehayias, Ted Krueger
Publisher: Red gate books 2011
Number of pages: 358
SQL Server-related performance problems come up regularly and diagnosing and solving them can be difficult and time consuming. Read SQL Server MVP Jonathan Kehayias' Troubleshooting SQL Server: A Guide for the Accidental DBA for descriptions of the most common issues and practical solutions to fix them quickly and accurately.
Home page url
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 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.
by Richard Waymire, Rick Sawtell - Sams
The book introduces you to every aspect of Microsoft's flagship back-end database engine. Organized with a FAQ-like summary at the end of every chapter, it familiarizes you with all the features and even brings you up to expert level on a few of them.
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.