To get the free app, enter your mobile phone number.
Inside Microsoft® SQL Server 2005: Query Tuning and Optimization (Developer Reference) Paperback – September 22, 2007
Frequently Bought Together
Customers Who Bought This Item Also Bought
From the Publisher
-Provides deep background information along with best practices that help developers build and optimize more-responsive databases
-Features numerous code samples and table examples
About the Author
Kalen Delaney, a Microsoft MVP for SQL Server since 1993, provides advanced SQL Server training to clients worldwide. She is a contributing editor and columnist for SQL Server Magazine and the author of several highly regarded books, including Microsoft SQL Server 2008 Internals.
Ron Talmage is a mentor with SolidQ. He is a SQL Server MVP, PASS Northwest US Regional Mentor, and current Chapter Leader of the Redmond-based Pacific Northwest SQL Server Users Group. He has been involved with SQL Server since version 4.21a, and has contributed to numerous SQL Server white papers and articles. His current focus is on database administration for relational data warehouses using SQL Server.
Adam Machanic lives in Boston, is a regular usergroup speaker and has written for SQL Server magazines. He's a Microsoft MVP and Certified IT Professional and previously wrote Expert SQL Server 2005 Development (APress).
Top Customer Reviews
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. You have the sense that they spent lots of time at trade shows touting the latest horde of "features", and little time coding under the strain of deadlines and client expectations. To them, every SQL Server nuance is always useful and wonderful and should get fair mention :(
This is a simple example, but SQL Tuning tells me that table scans are normally fine when selecting above 20% of rows, and index seeks are good for row counts under a percent, the space between depending on circumstance (which gray space the book goes on to address). This book, meanwhile, provides no real guidance, and tells me that table scans can be good, and indexes are useful too, and that SQL Server handles both nicely, and that the optimizer selects one or the other, and that it uses iterators, and that they are important, and that you can see what the optimizer has selected, and that you can change that if you want, and that you can automate the change, and that you can document the change, and here are the 4 related undocumented stored procs, and that this is new for 2005, and that there are other related matters, and that SQL Server has all this. Thanks!
Seems they are always plugging the product and never can admit to having suffered with its complexity.Read more ›
Chapter 1 - A Performance Troubleshooting Methodology by Sunil Agarwal (Program Manager in the SQL Server Storage Engine Group at Microsoft.) The opening chapter introduces the many factors that influence query performance. Although it fails to connect every dot, the chapter is a comprehensive overview of SQL Server performance and a sound intro for readers without a solid background in SQL Server.
Chapter 2 - Tracing and Profiling by Adam Machanic (SQL Server MVP. Leader of the New England SQL Server User Group in Boston, and all around smart guy.) Even if you use Profiler daily, you'll pick up some useful info in this thorough converge of SQL Server Engine Trace and the Profiler UI.
Chapter 3 - Query Execution by Craig Freedman (Microsoft SQL Server Query Execution Team.) This chapter has more beef than a 16 oz filet in Kansas City. Wow. If you enjoy reading Query execution plans, then you'll read this chapter 3 or 4 times. There's deep knowledge in here you won't find anywhere else. I've lost sleep wondering about some of the questions answered by this chapter, and I've lost more sleep reading it.
Chapter 4 - Troubleshooting Query Performance by Kalen Delaney and Craig Freedman. This is the practical part two of Craig's amazing chapter 3.Read more ›
Because of this book, within a matter of days I went from clueless to expert in reading query execution plans, creating effective indexes, and tuning my queries. By making my application much more responsive, I am sure I retained countless customers. Another big benefit: I am saving thousands of dollars per year on postponing or cancelling hardware upgrades (more processors, faster disk/raid systems, etc) that I thought were necessary to support my users. With my queries tuned and optimized, it looks like I can handle 4-5 times the load on my current infrastructure than I had previously thought.
This book really is a must read for anyone with a web application with even a modestly sized database, who is concerned with performance and scalability.
Most Recent Customer Reviews
I've always liked and preferred publisher Microsoft, especially on issues that are of domain ownership. Its content seems appropriate and well treated the subject matter. Read morePublished on June 24, 2014 by Pablo Zurita
Very good book. Work very well with SQL Server INTERNALS - Kalen Delaney. I recommend for new e experts dbas.Published on August 16, 2013 by Rafael Dontal Gonçalez
The Microsoft Press books about SQL Server are typically edited by Kalen Delaney who seems to have damn good standards for readability and coverage of the topics. Read morePublished on July 13, 2013 by John Palmer
I love Kalen Delaney , she is one of those writers who has the gift to tell the story in such a way that complex tasks become simple to understand . Read morePublished on February 4, 2011 by Michel Posseth
Needed this book to solve Sql 2005 performance issues. Went online and ordered this book - got the book in the promised time and in excellent condition. Read morePublished on February 8, 2010 by Amazon Customer
SQL performance tuning is probably one of those things you can do to really make a HUGE difference in performance. Read morePublished on February 7, 2008 by Denis Gobo
I have read around 25 SQL 7/2000/2005 books including all 3 books and 1 pamphlet from Kalen Delaney. Read morePublished on January 14, 2008 by Jaewoo Kim
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. Read morePublished on December 12, 2007 by Regan H. Thacker