Binding: Paperback Dewey Decimal Number: 005.2768 EAN: 9780735621961 ISBN: 0735621969 Label: Microsoft Press Manufacturer: Microsoft Press Number Of Items: 1 Number Of Pages: 448 Publication Date: September 26, 2007 Publisher: Microsoft Press Sales Rank: 16347 Studio: Microsoft Press
Product DescriptionDive deep into the internals of query tuning and optimization in SQL Server 2005 with this comprehensive reference. Understanding the internals of SQL Server helps database developers and administrators to better create, access, and effectively process information from enterprise data. Written by experts on SQL Server, this volume from the Inside Microsoft SQL Server series of books focuses on query tuning and optimization. Youll take an in-depth look at the best ways to make queries more efficient and effective, while maximizing existing resources. Includes extensive code samples and table examples to help database developers and administrators understand the intricacies and help promote mastery of query tuning and optimization.
Customer Reviews
Average Rating:
Rating: - Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization
SQL performance tuning is probably one of those things you can do to really make a HUGE difference in performance. Let's put this in perspective: take a typical application, if you can improve the performance by 100% then you really made a huge improvement. You can improve a SQL query by 1000% with 2 lines of code (sometimes all you have to do is take away a % sign). If you can make a query sargable so that the optimizer can do an index seek instead of an index scan your query might go from 12 seconds ... Read More
Rating: - A must-have for tuning SQL Queries
I rarely review books, but for this one I feel compelled to do so. I knew that SQL Queries were creating major bottlenecks in my web application, but I did not know which ones they were and how to fix them. My app was already live with thousands of users, and since I am primarily a web developer (and not a database expert), I needed practical help, and fast.
Because of this book, within a matter of days I went from clueless to expert in reading query execution plans, creating effective indexes, ... Read More
Rating: - A must for serious SQL 2005 specialists
I have read around 25 SQL 7/2000/2005 books including all 3 books and 1 pamphlet from Kalen Delaney. This is by far the best Kalen Delaney book and one of the best SQL 2005 books.
Unlike her other SQL 2005 book (SQL 2005 Storage Engine), this book does not suffer from convoluted and often incomprehensible writing.
This book covers (and covers it well):
1)Performance tuning using different indexes.
2)SQL execution plans and what each process means.
3)Explanation of ... Read More
Rating: - Books Online gone prolix
I was disappointed with this book, which I bought together with SQL Tuning by Dan Tow, hoping to get well-digested expert advice. SQL Tuning was all that I hoped for, and I highly recommend it.
This book, though, has that creepy quality so common to MSFT Press books, where very knowledgeable people, usually connected with the MSFT development teams, list feature after feature in long, passive-voice descriptions, failing to discriminate for the reader and advise as to what is useful and what is not. ... Read More
Rating: - Good coverage
I am only half way through this book, but the information it has given me has been valuable. I am excited to further test out the information, as well as learn more.
I have had issues using the Profiler before and was looking for more help. This book has provided it.
It does go a bit long for the issues I'm looking at, but I have been impressed so far.
- Review of Inside Microsoft SQL Server 2005 Query Tuning and Optimization
- Books Online gone prolix
- Good coverage
