Troubleshooting SQL Server – A Guide for the Accidental DBA

by: Jonathan Kehayias (Author),Ted Krueger(Author)

Publisher: Red Gate Books

Publication Date: September 26, 2011

Language: English

Print Length: 370 pages

ISBN-10: 1906434786

ISBN-13: 9781906434786

Book Description

We spend much of our working life trying to help people solve SQL Server-related performance problems, either hands-on, during consulting, or on various online community forums. Over the years, we’ve been exposed to a few weird-and-wonderful SQL Server issues but, mainly, we’ve seen the same problems and the same misconceptions about how SQL Server works crop up time-and-again. This book is our attempt to describe, diagnose, and solve some of the most common problems associated with the currently-supported versions of SQL Server: SQL Server 2005, 2008, and 2008 R2.
We spend much of our working life trying to help people solve SQL Server-related performance problems, either hands-on, during consulting, or on various online community forums. Over the years, we’ve been exposed to a few weird-and-wonderful SQL Server issues but, mainly, we’ve seen the same problems and the same misconceptions about how SQL Server works crop up time-and-again. This book is our attempt to describe, diagnose, and solve some of the most common problems associated with the currently-supported versions of SQL Server: SQL Server 2005, 2008, and 2008 R2.