|
SQL Server 2008 Query Performance Tuning Distilled (Expert's Voice in SQL Server) |  | Authors: Grant Fritchey, Sajal Dam
Publisher: Apress
Category: Book
List Price: $54.99
Buy New: $32.36
as of 7/30/2010 03:43 CDT details
You Save: $22.63 (41%)
New (26) Used (14) from $32.36
Seller: best_bargain_books3
Rating:  14 reviews
Sales Rank: 24310
Media: Paperback
Edition: 1
Pages: 600
Number Of Items: 1
Shipping Weight (lbs): 1.6
Dimensions (in): 9.1 x 7 x 1.3
ISBN: 1430219025
Dewey Decimal Number: 005
EAN: 9781430219026
ASIN: 1430219025
Publication Date: March 16, 2009
Availability: Usually ships in 1-2 business days
| |
| Features:
| • | ISBN13: 9781430219026 | | • | Condition: New | | • | Notes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, prices and service to the competition. 100% Satisfaction Guaranteed |
|
| Also Available In:
|
| Similar Items:
| |
| Editorial Reviews:
Product Description
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter’s domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day–to–day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area. - Emphasizes the practical. Does not bury readers in theory.
- Gives readers practical techniques to immediately apply in their daily work.
- Dedicates a chapter to each of the most common, performance–related problem areas.
What you’ll learn - Identify and fix poorly performing queries that are hurting your business.
- Read query execution plans and identify bottlenecks in performance.
- Record system performance metrics for trend analysis.
- Learn to design databases and write Transact–SQL code to avoid common problems.
- Understand what an index is, what it does, and how to build one.
- Use industry accepted best practices and understand how to develop your own to arrive at optimal database performance.
Who is this book for SQL Server Query Performance Tuning Distilled is aimed at anyone writing business–critical Transact–SQL queries, and also at those responsible for the continued good performance of those queries. Developers, database administrators, business intelligence analysts, and any others who develop Transact–SQL queries will find this book an indispensible resource for getting the most out of what SQL Server 2008 has to offer.
|
| Customer Reviews:
Showing reviews 1-5 of 14
 SQL Server 2008 Query Performance Tuning Distilled April 14, 2010
Jose Tigeleiro (Budd Lake, NJ USA)
2 out of 4 found this review helpful
Book delivered quickly and in new condition.
The book is a clearly written book with detailed information.
Smarter for reading this book March 16, 2010
Kathi Kellenberger (Edwardsville, IL USA)
3 out of 4 found this review helpful
One of the best things for me about this book was that I was able to read most of it while riding the bus to work. Grant did such a good job of explaining the results of each step, I was able to understand each point without trying it out for myself on a computer. I think I am pretty good with T-SQL and query tuning, but, by reading this book, I now have a methodical way to address performance problems.
A consummate approach to performance tuning with SQL Server March 9, 2010
John Jakubowski (Columbus, OH USA)
2 out of 3 found this review helpful
I found this book extremely valuable to me as a means of learning how to effectively tune SQL Server systems and workloads. I also expect it to continue providing value as a trusted reference resource. The insight provided regarding how the multitude of system processes interact and affect performance was clearly and concisely presented. Anyone developing for or administering a SQL Server based system will find significant value in reading this book. Overall it is a superb source of information providing tools, techniques, and an analysis framework to help address performance in a systematic and holistic manner. I would recommend this book to anyone dealing directly, or otherwise, with performance of a SQL Server instance or application. The introduction stated "With the right tools, you can tackle performance problems with a calmness and reliability..." and the book absolutely delivers in providing those tools. If you work with SQL Server you should have this book in your library and kept close at hand.
Performance Tuning actually distilled December 21, 2009
Rajkumar Ramasamy (Monrovia, CA, USA)
3 out of 3 found this review helpful
A very good reference book on SQL server performance tuning on diverse directions.
On the initial chapters, you can find a good introduction on Performance tuning, Performance analysis and on the Database Engine Tuning Advisor. There are various analysis and optimization techniques explained in later chapters. There is comprehensive information about most common performance issues that occurs due to Query designs and deadlocks.
We can find more information on tuning indexes like when and where to apply what type of index. Later, the workload optimization techniques explains ways to identify and research expensive queries and jobs and "What not" to do to avoid performance issues. This book helps not only to write individual queries without any performance flaws, it also helps to find where the flaws are in existing queries. I would like to mention that there are good of examples of queries (which everyone look for) which make the reader to understand where performance issues or bottlenecks occur and what to do with it.
One good sense I had when I started reading the book is it isn't that hard to read through the book even you are new to performance tuning in SQL server. I would strongly recommend this book for all database performance professionals (Even the beginners in Performance Tuning).
 Good guide to sql server performance monitoring December 8, 2009
Stewart Gordon (Melbourne, Australia)
2 out of 3 found this review helpful
This is a detailed look at how to get the best out of your SQL Server databases. I found it immediately useful in my workplace ... great examples, easy to understand
Showing reviews 1-5 of 14
|
|
|
CERTAIN CONTENT THAT APPEARS ON THIS SITE COMES FROM AMAZON SERVICES LLC. THIS CONTENT IS PROVIDED ‘AS IS’ AND IS SUBJECT TO CHANGE OR REMOVAL AT ANY TIME. Copyright 2009, SQL Server 2008 Books. All Rights Reserved.
In association with Amazon.com | |
