Customer Reviews


2 Reviews
5 star:
 (2)
4 star:    (0)
3 star:    (0)
2 star:    (0)
1 star:    (0)
 
 
 
 
 
Average Customer Review
Share your thoughts with other customers
Create your own review
 
 
Most Helpful First | Newest First

2 of 2 people found the following review helpful
5.0 out of 5 stars The book to have beside you when you are writing T-SQL, 26 July 2012
By 
J. Allen "Fatherjack" (UK) - See all my reviews
(REAL NAME)   
This is an excellent book, written to accompany SQL Server 2012 but a lot of the theory and recommendations equally apply to previous versions of SQL Server.

It's well structured, clearly written and will improve understanding of why things done one way are better than possible alternatives. Experienced DBAs or developers will find something to learn from this book, people new to the SQL Server or specifically T-SQL may need an intro to T-SQL to go hand-in-hand with this one as it is not set at an introductory level.

I have heard there were some early copies that Amazon managed to print with print-setting issues but they are offering free replacements for all of these so I have no issues with recommending it to anyone.
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


1 of 1 people found the following review helpful
5.0 out of 5 stars Everything you want to know about indexes and performance, 16 April 2013
Hi,

I have written a chapter-by-chapter review of this book on "[...]" the first part of this review follows:

Indexes are a primary means of making performance improvements on SQL Server. This book aims to tell you all you need to know about indexes, and more importantly, provides a methodological approach to index tuning, turning what is often viewed as an art into a science.

Indexes are typically a dry subject matter, however they are fundamental to both understanding the structure of data and helping improve query performance. The examples provided make the subject interesting and accessible.

Before reading the book, I had a list of questions that I hoped would be covered, this would let me know how detailed the book was. It successfully answered most of my questions - showing me the book had both depth and quality. These questions included:

*Will it use practical examples to illustrate a point?

*Does it mention the plan cache as an input to the DTA?

*Does it identify the limit in the number of missing indexes?

*Will it tell me how to fix a corrupt index?

*Will it provide scripts to automatically optimize my databases?

I did wonder why anyone would want to write a book solely about indexes. After all, if you wanted to know about a given make of car, would you buy a book that's only about the car's engine? The answer I think, from a performance perspective, is yes.

Thanks
Ian
Help other customers find the most helpful reviews 
Was this review helpful to you? Yes No


Most Helpful First | Newest First

This product

Only search this product's reviews