Message from Dean - May 8th 2007
I am currently testing out a new version of the APF Bridge Component - If you notice any errors within this demo store please drop me a line.
List Price: $49.99Amazon.com's Price: $44.79 You Save: $5.20 (10%)Prices subject to change.
Availability: Usually ships in 24 hours
This item ships for FREE with Super Saver Shipping.
Binding: Paperback
Dewey Decimal Number: 005.7585
EAN: 9781590594216
Edition: 2nd
ISBN: 1590594215
Label: Apress
Manufacturer: Apress
Number Of Items: 1
Number Of Pages: 624
Publication Date: October 11, 2004
Publisher: Apress
Studio: Apress
Alternate Versions: Click to Display
Accessories:
Related Items:
Browse for similar items by category:
Editorial Review:
Product Description:
...very user-friendly, easy to understand, very well designed, and fun to read. I don't feel like this book bogs you down with all of the internal details that a lot of the other books do.
— Aaron Weiker Weblog
Many SQL Server-based applications perform far below expectation&emdash;costing money and time. And until now, there has been very little practical information available that explains how to identify and cure performance problems in SQL Server. But this book offers essential content to fill in the gap.
SQL Server Query Performance Tuning Distilled, Second Edition includes updated material plus one new chapter, and explains how to design and tune SQL Server applications to cope with ever-increasing workloads. With proven strategy, this book teaches you how to use SQL Server tools to identify a performance bottleneck, isolate the root cause, apply possible resolutions, and then quantify performance improvements. Also covered are crucial issues like index analysis and tuning, preventing deadlocks, optimizing workload, and minimizing costs.
Average Rating: 
Rating:  -
This book will explain you several things about optimization.
The thing I like most is that the author supply a lot of examples, he does not only tell you why something is better. He will show you the difference.
He covers other things related to performance like network, hard drives, memory. I think this is a good book to have around.
Rating:  -
This is a good performance tuning book for SQL Server. It covers all the topics from writing Efficient T-SQL Code to Query Tuning, Optimization, Indexing, Troubleshooting and Best Practices. This book is a Good addition to the SQL Library.
Rating: -
I'm a developer, not a DBA. Reading this book took me from having a mish-mash of fuzzy tuning concepts to being solid at tuning. If you take the time to read (and absorb) this book cover-to-cover, you will find yourself more knowledgable than almost any developer you meet - and many DBAs as well, quite frankly.
This book is a bible for doing *measurable*, *repeatable*, and *useful* SQL Server tuning. Using the techniques and procedures in this book, you be able to find exactly what the problem is, and how to fix it. I would give it 10 stars, if only I could.
Rating: -
Very good book. Even for the beginners it is easy to catch up. I loved reading it many times. Author use simple table structure and explain how they differ when they tuned and when not tuned.
Looking forward to 2005 Edition if there is one going to come out.
I did not buy from amazon, i bought offshelf. I was impressed with this material so write up here. I like some other books from J. Sack from Apress and Solid Quality Learning (microsoft press).
these books my collection and they are excellent : This Book, J Sack Books from Apress and SQL books from Microsoft press ...
Rating: -
This book is perhaps the best and most useful technical book I've read in many years. I'm a seasoned developer with some good SQL experience but not much experience on the tuning side of the house (previously worked mostly with Oracle in large organizations where there was a DBA to perform the magic). Now I'm in a smaller organization where I have more exposure to the tuning aspects of SQL Server 2005.
This book does a fantastic job demystifying indicies, queries, bookmarks, execution plans -- the whole gamut. It starts by giving a great introduction so that the user understands the basics and then delves into strategies for optimization with pros and cons for each. The graphics and examples in the book are excellent as well.
A must read for anyone interested in query/db optimization.
Availability: Usually ships in 24 hours
|
Amazon Store 