Cover Image

Expert performance indexing in Azure SQL and SQL Server 2022 : toward faster results and lower maintenance both on premises and in the Cloud /

Take a deep dive into perhaps the single most important facet of query performance--indexes--and how to best use them. Newly updated for SQL Server 2022 and Azure SQL, this fourth edition includes new guidance and features related to columnstore indexes, improved and consolidated content on Query St...

Full description

Bibliographic Details
Main Authors: Pollack, Edward, (Database administrator) (Author), Strate, Jason (Author)
Format: eBook
Language:English
Published: New York, NY : Apress, [2023]
Edition:4th ed.
Subjects:
SQL server.
Database management.
SQL (Computer program language)
Online Access:Connect to the full text of this electronic book
Table of Contents:
  • 1. Index Fundamentals
  • 2. Index Storage Fundamentals
  • 3. Examining Index Contents
  • 4. Fragmentation
  • 5. Index Metadata and Statistics
  • 6. XML Indexes
  • 7. Spatial Indexing
  • 8. Indexing Memory-Optimized Tables
  • 9. Full-Text Indexing
  • 10. Indexing Myths and Best Practices
  • 11. Index Maintenance
  • 12. Indexing Tools
  • 13. Indexing Strategies
  • 14. Query Strategies
  • 15. Monitoring Indexes
  • 16. Index Analysis
  • 17. Indexing Methodology.