Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your email address or mobile phone number.

Expert Performance Indexing for SQL Server 2012 1st Edition

4.8 out of 5 stars 5 customer reviews
ISBN-13: 978-1430237419
ISBN-10: 1430237414
Why is ISBN important?
This bar-code number lets you verify that you're getting exactly the right version or edition of a book. The 13-digit and 10-digit formats both work.
Scan an ISBN with your phone
Use the Amazon App to scan ISBNs and compare prices.
Sell yours for a Gift Card
We'll buy it for $7.40
Learn More
Trade in now
Have one to sell? Sell on Amazon
Try the eTextbook for free On clicking this link, a new layer will be open
$0.00 On clicking this link, a new layer will be open
Buy new On clicking this link, a new layer will be open
$45.77 On clicking this link, a new layer will be open
More Buying Choices
28 New from $34.57 16 Used from $52.22
Free Two-Day Shipping for College Students with Amazon Student Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student

Save Up to 90% on Textbooks Textbooks
$45.77 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.

Frequently Bought Together

  • Expert Performance Indexing for SQL Server 2012
  • +
  • SQL Server 2012 Query Performance Tuning (Expert's Voice in SQL Server)
  • +
  • Microsoft SQL Server 2012 Internals (Developer Reference)
Total price: $142.58
Buy the selected items together

Editorial Reviews

About the Author

Jason Strate is a database architect and administrator with more than 15 years of experience. He has been a recipient of Microsoft's "Most Valuable Professional" designation for SQL Server since July 2009. His experience includes design and implementation of both OLTP and OLAP solutions, as well as assessment and implementation of SQL Server environments for best practices, performance, and high availability solutions. Jason is a SQL Server MCITP and participated in the development of Microsoft Certification exams for SQL Server 2008.

Jason is actively involved with his local PASS chapter (SQL Server User Group) and serves as its director of program development. Jason worked with the board to organize the PASSMN SQL Summit 2009 for the local community. Jason enjoys helping others in the SQL Server community and does this by presenting at technical conferences and user group meetings. Most recently, Jason has presented at the SSWUG Virtual Conferences, TechFuse, numerous SQL Saturdays, and at PASSMN user group meetings.

Jason is a contributing author for the Microsoft whitepaper Empowering Enterprise Solutions with SQL Server 2008 Enterprise Edition. Jason is an active blogger with a focus on SQL Server and related technologies.


Product Details

  • Paperback: 354 pages
  • Publisher: Apress; 1 edition (July 3, 2012)
  • Language: English
  • ISBN-10: 1430237414
  • ISBN-13: 978-1430237419
  • Product Dimensions: 7.5 x 0.8 x 9.2 inches
  • Shipping Weight: 1.7 pounds (View shipping rates and policies)
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #904,927 in Books (See Top 100 in Books)

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

5 star
4 star
3 star
2 star
1 star
See all 5 customer reviews
Share your thoughts with other customers

Top Customer Reviews

Format: Paperback Verified Purchase
I love this book so much, that I have both versions: ebook and the regular paper book version at work.

The reason why I like this book so much, is that it goes more in-depth in terms of Index tuning and theory than any other book in the market. Almost every MS-SQL tuning book talks about Index strategies, but this book talks exclusively about Indexes, so you get much more information and more explanations that maybe you are not able to get on other books because the normal book's size limitation that publisher impose.

The book start with basic theory, which I fully recommend. Even though I'm not new on this topic, I found lot interesting information that gives me a fresh perspective about how my tuning strategy should work (or why is not working as I was expecting) These intro topics are focused but not limited to Index storage, Index fundamentals and T-SQL syntax.

After the mandatory theory, authors talk about Index tuning and good practices, available Tuning Tools for Indexes and how to validate the performance on those Indexes that have been deployed already.

The book ends showing a few examples about how T-SQL queries should be written while keeping performance in mind.

My only minor suggestion is that the book would be even better with much more illustrations than what it currently has. Not saying there are not illustrations at all, but some topics like fragmentation, storage and Index's behavior when inserting or reading data have just a few illustrations that barely show the actual concept. Some lines on those specific chapters are a little bit difficult to follow because that. A book that really shines on that, but is a really a dated one, is MS-SQL 2000 Perf. Optimization and Tuning by Ken England.
Read more ›
Comment 9 of 9 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
This is the only index-specific book that I know of for SQL Server, and it was a long-overdue resource.

The progression of the book is very logical, from index fundamentals to special types of indexes, index maintenance to a method to analyze and implement changes. The examples and queries that are included are thorough yet understandable. You are given a solid foundation as to why you should do something, and the tools with which to do it. Another outstanding benefit to this book is that Jason and Ted have taken their years of working with business users and distilled that. This book goes beyond the purely technical reasons for doing something and encourages you to think about the impact to the business, the applications, and the users behind the databases.

This book is already one of the most valuable resources in my library. I know it will be referenced frequently (it already has been, and it's littered with Post-It flags). I recommend anyone that works with SQL Server - whether as a developer, a DBA, or any combination thereof - pick up this book and read it. You don't have to be a SQL Server expert to pick up this book and learn from it, and even experienced users will learn something new and interesting. You won't find a more comprehensive index resource anywhere.
Comment 6 of 6 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
Let's face it: indexing is a dry, dry subject. Yet, it is an area that can profoundly impact the performance of your database application or reports. The authors, Jason Strate and Ted Krueger, manage to turn this dry topic into an enjoyable read with many analogies and lots of real-world advice. Besides delving into the different types of indexes, reasons for using them, index tuning, and maintenance, they also provide a nice introduction to internals that won't make your eyes roll up into your head.

I recommend this book to all SQL Server DBAs and developers out there who care about performance!
Comment 4 of 4 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback

I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.

Indexes are a primary means of making performance improvements on SQL Server. This book aims to tell you all you need to know about indexes, and more importantly, provides a methodological approach to index tuning, turning what is often viewed as an art into a science.

Indexes are typically a dry subject matter, however they are fundamental to both understanding the structure of data and helping improve query performance. The examples provided make the subject interesting and accessible.

Before reading the book, I had a list of questions that I hoped would be covered, this would let me know how detailed the book was. It successfully answered most of my questions - showing me the book had both depth and quality. These questions included:

*Will it use practical examples to illustrate a point?

*Does it mention the plan cache as an input to the DTA?

*Does it identify the limit in the number of missing indexes?

*Will it tell me how to fix a corrupt index?

*Will it provide scripts to automatically optimize my databases?

I did wonder why anyone would want to write a book solely about indexes. After all, if you wanted to know about a given make of car, would you buy a book that's only about the car's engine? The answer I think, from a performance perspective, is yes.

Below is a chapter-by-chapter exploration of the topics covered, I've given each chapter its own rating.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Set up an Amazon Giveaway

Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more
Expert Performance Indexing for SQL Server 2012
This item: Expert Performance Indexing for SQL Server 2012
Price: $45.77
Ships from and sold by Amazon.com

Want to discover more products? Check out this page to see more: best performance computing