Programming Books C Java PHP Python Learn more Browse Programming Books
Qty:1
  • List Price: $49.99
  • Save: $17.01 (34%)
FREE Shipping on orders over $35.
Only 2 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Want it Monday, April 21? Order within and choose One-Day Shipping at checkout. Details
FREE Shipping on orders over $35.
Condition: Used: Like New
Comment: Used, but looks brand new. Only very slight signs of use. Cover and binding are undamaged, and pages are crisp and unmarked. Unbeatable customer service, and we usually ship the same or next day. Over one million satisfied customers!
Add to Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more

Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization Paperback – September 22, 2007


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from Collectible from
Paperback, September 22, 2007
$32.98
$4.10 $0.30

Frequently Bought Together

Inside Microsoft® SQL Server™ 2005: Query Tuning and Optimization + Inside Microsoft SQL Server 2005: T-SQL Programming (Pro-Developer) + Inside Microsoft SQL Server 2005: T-SQL Querying (Solid Quality Learning)
Price for all three: $100.39

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 436 pages
  • Publisher: Microsoft Press; 1 edition (September 22, 2007)
  • Language: English
  • ISBN-10: 0735621969
  • ISBN-13: 978-0735621961
  • Product Dimensions: 9 x 7.4 x 1 inches
  • Shipping Weight: 1.7 pounds (View shipping rates and policies)
  • Average Customer Review: 4.5 out of 5 stars  See all reviews (12 customer reviews)
  • Amazon Best Sellers Rank: #1,028,281 in Books (See Top 100 in Books)

Editorial Reviews

From the Publisher

Key Book Benefits:

-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).


More About the Author

Kalen Delaney has been working with SQL Server since 1987 when she joined the Sybase Corporation in Berkeley, California. Kalen has an independent international trainer and consultant since 1992. As a consultant, she has worked with both Microsoft Corporation and Sybase Corporation to develop courses and provide internal training for their technical support staff. Kalen has taught Microsoft Official Curriculum courses, as well as her own independently developed Advanced SQL Server Internals courses, to clients around the world. In addition, she has been writing regularly about SQL Server since 1995. Kalen is also a contributing editor and columnist for SQL Server Magazine and has been a SQL Server Most Valuable Professional since 1995.

Customer Reviews

4.5 out of 5 stars
5 star
8
4 star
3
3 star
0
2 star
1
1 star
0
See all 12 customer reviews
Don't read them first - first read the beginner's books.
John Palmer
The flow of the information is the right way to understand and then solve query performance issues.
Paul Nielsen
This is by far the best Kalen Delaney book and one of the best SQL 2005 books.
Jaewoo Kim

Most Helpful Customer Reviews

45 of 49 people found the following review helpful By Pushin' Fifty on January 14, 2008
Format: Paperback
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. 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 ›
3 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
26 of 32 people found the following review helpful By Paul Nielsen on October 12, 2007
Format: Paperback
At first glance, Inside SQL Server Query Tuning and Optimization, appears to be a multiple-author ensemble book with only 1½ chapters written by Kalen, which might be disappointing. However, the reality is that this database dream team is hand-picked by Kalen, and following Kalen's plan the book meets the high standards Kalen is known for. The flow of the information is the right way to understand and then solve query performance issues.

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 ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
2 of 2 people found the following review helpful By Learns Divine on December 7, 2007
Format: Paperback
To be a good DBA you need to understand at least a little bit about database internals. Kalen's (ok, so it is co-authored) book gets you up to speed quickly and gives the level of detail needed to improve your skill set as a DBA. I haven't completed reading this book yet but have read the 2000 version. A lot of similar material, but more detail this time hence the need to break up the content into more than 1 book. I personally find her writing style easy to read.
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 5 people found the following review helpful By N. Mckechnie on January 19, 2008
Format: Paperback
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, 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.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Product Images from Customers

Most Recent Customer Reviews

Search
ARRAY(0xa62d6714)

What Other Items Do Customers Buy After Viewing This Item?