Programming Books C Java PHP Python Learn more Browse Programming Books
Expert Performance Indexing for SQL Server 2012 and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $49.99
  • Save: $10.00 (20%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Expert Performance Indexi... has been added to your Cart
FREE Shipping on orders over $35.
Condition: Used: Good
Comment: This is a used text in good condition. It may have some writing and highlighting. Ships directly from Amazon. Eligible for free super saver shipping.
Access codes and supplements are not guaranteed with used items.
Trade in your item
Get a $17.80
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Expert Performance Indexing for SQL Server 2012 Paperback – July 3, 2012

ISBN-13: 978-1430237419 ISBN-10: 1430237414 Edition: 1st

Buy New
Price: $39.99
35 New from $35.99 13 Used from $33.99
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$39.99
$35.99 $33.99
Amazon%20Web%20Services

$39.99 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 High-Performance T-SQL Using Window Functions (Developer Reference)
Price for all three: $116.59

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: 354 pages
  • Publisher: Apress; 1 edition (July 3, 2012)
  • Language: English
  • ISBN-10: 1430237414
  • ISBN-13: 978-1430237419
  • Product Dimensions: 9.2 x 7.5 x 0.7 inches
  • Shipping Weight: 1.3 pounds (View shipping rates and policies)
  • Average Customer Review: 4.8 out of 5 stars  See all reviews (4 customer reviews)
  • Amazon Best Sellers Rank: #229,008 in Books (See Top 100 in Books)

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.


More About the Authors

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

Customer Reviews

4.8 out of 5 stars
5 star
3
4 star
1
3 star
0
2 star
0
1 star
0
See all 4 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

5 of 5 people found the following review helpful By Jose on September 10, 2012
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 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 4 people found the following review helpful By Jes Schultz Borland on January 3, 2013
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 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
3 of 3 people found the following review helpful By Kathi Kellenberger on December 31, 2012
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 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
Format: Paperback
Hi,

I have written a chapter-by-chapter review of this book on "www i-programmer info" the first part of this review follows:

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.

Thanks
Ian
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