Đang chuẩn bị liên kết để tải về tài liệu:
Expert Performance Indexing for SQL Sever 2012

Indexes are important. Not only that, they are vastly important. No single structure aids in retrieving data from a database more than an index. Indexes represent both how data is stored and the access paths by which data can be retrieved from your database. Without indexes, a database is an unordered mess minus the roadmap to find the information you seek. Throughout my experience with customers, one of the most common resolutions that I provide for performance tuning and application outages is to add indexes to their databases. Often, the effort of adding an index or two to the primary tables within a database provides significant. | THE EXPERT S VOICE IN SQL SERVER for SQL Server 2012 MASTER THE ART AND SCIENCE OF INDEXING IN SQL SERVER 2012 Jason Strato and Ted Krueger Apress For your convenience Apress has placed some of the front matter material after the index. Please use the Bookmarks and Contents at a Glance links to access them. Apress Contents at a Glance About the Author.xv About the Technical Reviewer.xvii Acknowledgments.xix Introduction.xxi Chapter 1 Index Fundamentals.1 Chapter 2 Index Storage Fundamentals.15 Chapter 3 Index Statistics.51 Chapter 4 XML Spatial and Full-Text Indexing.91 Chapter 5 Index Myths and Best Practices.121 Chapter 6 Index Maintenance.135 Chapter 7 Indexing Tools.165 Chapter 8 Index Strategies.187 Chapter 9 Query Strategies.235 Chapter 10 Index Analysis.249 Index.325