SQL Server 2005 Practical Troubleshooting: The Database Engine

by Ken Henderson

Never-Before-Published Insiders Information for Troubleshooting SQL Server 2005. This is the definitive guide to troubleshooting the Microsoft SQL Server 2005 database engine, direct from the people... This description may be from another edition of this product.

• Format: Paperback
• Language: English
• ISBN: 0321447743
• ISBN13: 9780321447746
• Release Date: January 2006
• Publisher: Addison-Wesley Professional
• Length: 480 Pages
• Weight: 1.45 lbs.
• Dimensions: 1.0" x 7.9" x 8.6"

Customer Reviews

Excellent

Excellent is the word.... great book.... We miss Ken Henderson.... only you could make this possible... He was the real GURU for all guru of sql server.......

WOW!

I cannot believe how much you get for your money with this book. Very informative.

Book in need, book Indeed - Review of Database Administrator SQLAuthority.com

SQLAuthority.com Book Review : SQL Server 2005 Practical Troubleshooting: The Database Engine (SQL Server Series) (Paperback) by Ken Henderson Short Review : Database Administrators can use this book on a daily basis in SQL Server 2005 troubleshooting and problem solving. Answers to SQL issues can be swiftly located using the index of this book.This book covers the topics and subjects which any other books, blogs or websites (including MSDN, BOL) do not cover. This book provides DBAs with solutions which can be used by user in highly dynamic environments to resolve common and specialized problems. This book tells user what to do when something goes wrong with SQL Server 2005. This book is an edge case, but is something that can make the difference between a SQL Server application meeting customer needs and it going down in flames. This book is a good place to begin troubleshooting expedition. Detail Review : This book will not teach you basic T-SQL from basic and it is not easy and interesting training text book. This book is more like guide to save the troubled time. This book must be read by all the DBA before hand to know what kind of bad (worst!) situation can arise and how this book can be used to prevent the situation or fix it if it has already happened. The authors obviously knows the product very well from inside out, many of the authors are working for Microsoft or MVP. The authors communicate the the topic very well, many places there is lots of code dump, however that is appropriately justified looking at the content covered in the book and direction of the topic taken in the book. The Authors unveils the secretes of SQL Server 2005 internals. We can easily understand how the SQL Server 2005 is working, which helps when something goes wrong. This book contains many interesting topics. Regular readers of my blog knows that my favorite subject is data corruption and recovery and server crashes and other critical failures. I enjoy writing and researching SQL Server errors and their resolution. It is extremely important to know the common errors and their solution. This book covers errors in depth and in detail. This book tries to cover many subjects in 480 pages, which makes sometime book little heavy to read. The book covers complex subject very easily and in simple words. For example, "Last Known Good - When was the last time DBCC CHECKDB reported no errors for this database? SQL Server 2005 saves in the database information about the last time a DBCC CHECKDB was run without errors on the database." "Run DBCC FREEPROCCACHE. This clears the procedure cache of any cached plans that are not currently in use." "No matter how accurate the planning or estimate is, you might still run out of space in production. The best practice here is to set up the SQLDiag service to constantly monitor the production system and take action before you run out of space." This book comes up with CD which contains some useful software (SQL Nexus; TraceBu

Excellent write ups for DBAs

This book contains articles and code examples that are very handy, especially to those of us who are transitioning from SQL 2000 to SQL 2005. I am a fairly new DBA and have much to learn, but this book opened the door to some more advanced topics (index statistics and execution plans for example) and described the differences between how SQL 2K and SQL 2005 handle the same issues. Highly recommended.

Nice book, detailed data

The book is well written, contains lots of description for troubleshooting of complex problems. I think the book is one of "better to have" for every good MSSQL DBA. I like sections about memory management, query optimizator, backup and recovery - and every chapter in the book contains lots of valuable information. Also the book written in good and easy to understand English - there are no (or few) of complex grammatic which may make reading hard for foreigners.