- Cover
- Title
- Copyright
- Dedication
- Contents at a Glance
- Contents
- About the Authors
- About the Technical Reviewer
- Introduction
- Chapter 1: Index Fundamentals
- Chapter 2: Index Storage Fundamentals
- Chapter 3: Index Metadata and Statistics
- Chapter 4: XML Indexes
- Chapter 5: Spatial Indexing
- Chapter 6: Full-Text Indexing
- Chapter 7: Indexing Memory-Optimized Tables
- Chapter 8: Indexing Myths and Best Practices
- Index Myths
- Myth 1: Databases Don’t Need Indexes
- Myth 2: Primary Keys Are Always Clustered
- Myth 3: Online Index Operations Don’t Block
- Myth 4: Any Column Can Be Filtered in Multicolumn Indexes
- Myth 5: Clustered Indexes Store Records in Physical Order
- Myth 6: Indexes Always Output in the Same Order
- Myth 7: Fill Factor Is Applied to Indexes During Inserts
- Myth 8: Deleting Form Heaps Results in Unrecoverable Space
- Myth 9: Every Table Should Have a Heap/Clustered Index
- Index Best Practices
- Summary
- Index Myths
- Chapter 9: Index Maintenance
- Chapter 10: Indexing Tools
- Chapter 11: Indexing Strategies
- Chapter 12: Query Strategies
- Chapter 13: Monitoring Indexes
- Chapter 14: Index Analysis
- Chapter 15: Indexing Methodology
- Index
Expert Performance Indexing in SQL Server
Second Edition
Jason Strate
Grant Fritchey
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.