Troubleshooting SQL Server: A Guide for the Accidental DBA
by Jonathan Kehayias, Ted Krueger
Publisher: Red gate books 2011
ISBN/ASIN: 1906434786
ISBN-13: 9781906434786
Number of pages: 358
Description:
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.
Download or read it online for free here:
Download link
(2.3MB, PDF)
Similar books
SQL Server Reference Guideby Buck Woody - Pearson Education
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, this Reference Guide covers SQL Server 2000 up to SQL Server 2008 R2.
(8118 views)
SQL Server Statisticsby 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.
(10071 views)
Inside the SQL Server Query Optimizerby 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.
(10355 views)
Defensive Database Programming with SQL Serverby Alex Kuznetsov - Red Gate Books
The goal of Defensive Programming is to produce resilient code that responds gracefully to the unexpected. In this book, you will find practical programming techniques that will improve the quality of your T-SQL code and increase its robustness.
(13087 views)