Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.

  • Apple
  • Android
  • Windows Phone
  • Android

Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.

Kindle-Preis: EUR 26,32
inkl. MwSt.

Diese Aktionen werden auf diesen Artikel angewendet:

Einige Angebote können miteinander kombiniert werden, andere nicht. Für mehr Details lesen Sie bitte die Nutzungsbedingungen der jeweiligen Promotion.

An Ihren Kindle oder ein anderes Gerät senden

An Ihren Kindle oder ein anderes Gerät senden

Facebook Twitter Pinterest
Expert Performance Indexing for SQL Server 2012 von [Strate, Jason, Krueger, Ted]

Expert Performance Indexing for SQL Server 2012 Kindle Edition

Alle Formate und Ausgaben anzeigen Andere Formate und Ausgaben ausblenden
Neu ab Gebraucht ab
Kindle Edition
"Bitte wiederholen"
EUR 26,32

Kindle Storyteller 2016: Der Deutsche Self Publishing Award
Kindle Storyteller 2016: Der Deutsche Self Publishing Award
Von 15. Juni bis 15. September Buch hochladen und tollen Preis gewinnen Jetzt entdecken



Expert Performance Indexing for SQL Server 2012 is a deep dive into perhaps the single-most important facet of good performance: indexes, and how to best use them. The book begins in the shallow waters with explanations of the types of indexes and how they are stored in databases. Moving deeper into the topic, and further into the book, you will look at the statistics that are accumulated both by indexes and on indexes. All of this will help you progress towards properly achieving your database performance goals.

What you'll learn from Expert Performance Indexing for SQL Server 2012 will help you understand what indexes are doing in the database and what can be done to mitigate and improve their effects on performance. The final destination is a guided tour through a number of real-world scenarios and approaches that can be taken to investigate, mitigate, and improve the performance of your database.

  • Defines indexes and provides an understanding of their role

  • Uncovers and explains the statistics that are kept in indexes

  • Teaches strategies and approaches for indexing databases

What you’ll learn

  • Fully understand the index types at your disposal

  • Recognize and remove unnecessary indexes

  • Review statistics to understand indexing choices made by the optimizer

  • Properly apply strategies such as covering indexes, included columns, index intersections, and more

  • Write queries to make good use of the indexes already in place

  • Design effective indexes for full-text, spatial, and XML data types

  • Manage the big picture: Encompassing all indexes in a database, and all database instances on a server

Who this book is for

Expert Performance Indexing for SQL Server 2012 is intended for database administrators and developers who are ready to boost the performance of their environments without the need to go in blindly building indexes.

Über den Autor und weitere Mitwirkende

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.


  • Format: Kindle Edition
  • Dateigröße: 6469 KB
  • Seitenzahl der Print-Ausgabe: 344 Seiten
  • ISBN-Quelle für Seitenzahl: 1430237414
  • Verlag: Apress; Auflage: 1 (3. Juli 2012)
  • Verkauf durch: Amazon Media EU S.à r.l.
  • Sprache: Englisch
  • ASIN: B008J8L1KI
  • Text-to-Speech (Vorlesemodus): Aktiviert
  • X-Ray:
  • Word Wise: Nicht aktiviert
  • Verbesserter Schriftsatz: Nicht aktiviert
  • Durchschnittliche Kundenbewertung: Schreiben Sie die erste Bewertung
  • Amazon Bestseller-Rang: #424.474 Bezahlt in Kindle-Shop (Siehe Top 100 Bezahlt in Kindle-Shop)

  •  Ist der Verkauf dieses Produkts für Sie nicht akzeptabel?


Es gibt noch keine Kundenrezensionen auf
5 Sterne
4 Sterne
3 Sterne
2 Sterne
1 Stern

Die hilfreichsten Kundenrezensionen auf (beta) HASH(0x9263fba8) von 5 Sternen 6 Rezensionen
9 von 9 Kunden fanden die folgende Rezension hilfreich
HASH(0x8d538d80) von 5 Sternen The #1 Index tuning book in the market, at the time of this review. 10. September 2012
Von Jose - Veröffentlicht auf
Format: Taschenbuch Verifizierter Kauf
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.

In a nutshell, this is a very nice book about MS-SQL Indexes and almost every aspect that falls into that category: theory, storage, tuning, deployment. If you are new into MS-SQL performance tuning or want to take your Index tuning strategies to the next level, this is the right book for that. It benefits DBA and Developers, because touches both aspect of query performance.

Now, if you are serious about the topic or want to expand the knowledge more, I would also like to recommend Grant's book SQL Server 2012 Query Performance Tuning He mentions Index Tuning too, but in a more holistic approach. Grant's is a more "all around" tuning book, while "Expert Performance Indexing for SQL Server 2012" book focus on the Index aspect of the tuning only.
6 von 6 Kunden fanden die folgende Rezension hilfreich
HASH(0x8d538fcc) von 5 Sternen Every SQL Server professional should read this 3. Januar 2013
Von J Borland - Veröffentlicht auf
Format: Taschenbuch
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.
4 von 4 Kunden fanden die folgende Rezension hilfreich
HASH(0x8d6e3228) von 5 Sternen Indexing for DBA Heroes (or who want to be heroes) 1. Januar 2013
Von Kathi Kellenberger - Veröffentlicht auf
Format: Taschenbuch Verifizierter Kauf
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!
HASH(0x8d6e33cc) von 5 Sternen Everything you want to know about indexes and performance 16. April 2013
Von Ian Stirk - Veröffentlicht auf
Format: Taschenbuch

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.

Chapter 1 Index fundamentals

The chapter provides a comprehensive overview of what indexes are, the different types, and why they are important. The types of index discussed include heaps (sic), clustered, non-clustered, columnstore, xml, spatial, and full-text search. Also covered are primary keys, unique indexes, included columns, partitioned indexes, filtered indexes, and compression.

The various options used for creating an index are covered in good detail. These options include fillfactor, pad_index, sort_in_tempdb, ignore_dup_key, statisitics_norecompute, drop_existing, online, allow_row_locks, allow_page_locks, maxdop, data_compression, on partitions.

A brief overview of the system tables that contain index metadata is provided, including sys.indexes, sys.index_columns, sys.xml_indexes, sys.spatial_indexes, sys.column_store_dictionaries, and sys.column_store_segments.

Throughout the chapter there is an analogy made between indexes and books within a library. For example, the primary catalogue (e.g. book title) being equated with a clustered index, and a secondary catalogue (e.g. author name) with a non-clustered index. This is extended with the example of a large dictionary, where every letter has its own book, to reflect partitioning. Finally microfiche is used to reflect compression. (5/5)
This book probably covers everything you would want to know about indexes, it has great depth and range, is full of relevant examples, and has a methodological approach to performance tuning using indexes. The book is an excellent resource and will be useful to anyone looking to improve the performance of their SQL Server databases.
HASH(0x8d6e37a4) von 5 Sternen Awesome book - needs proofreading and a technical editor 15. Juni 2016
Von Th3MadScientist - Veröffentlicht auf
Format: Taschenbuch
Great book for a deeper dive into SQL Server indexing but I've came across tons of errors while reading it. Most of the errors are with the code samples in the e-book where a missing letter would throw an error if you tried to run the code yourself. Another very big mistake is the author's definition of a surrogate key. They define it as a column in the data that can uniquely identify one row, which is not correct. They are referring to a natural key, a surrogate key is not derived from table data.
Waren diese Rezensionen hilfreich? Wir wollen von Ihnen hören.
click to open popover