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
Introducing Microsoft SQL Server 2014by Ross Mistry, Stacia Misner - Microsoft Press
The authors explain how SQL Server 2014 incorporates in-memory technology to boost performance in online transactional processing and data-warehouse solutions. They also describe how it eases the transition from on-premises solutions to the cloud.
(8949 views)
Sams Teach Yourself Microsoft SQL Server 7 in 21 Daysby 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.
(17407 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.
(10051 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.
(9869 views)