Analytics optimization with columnstore indexes in Microsoft SQL Server : optimizing OLAP workloads /

Meet the challenge of storing and accessing analytic data in SQL Server in a fast and performant manner. This book illustrates how columnstore indexes can provide an ideal solution for storing analytic data that leads to faster performing analytic queries and the ability to ask and answer business i...

Full description

Bibliographic Details
Call Number:Libro Electrónico
Main Author: Pollack, Edward, (Database administrator) (Author)
Format: Electronic eBook
Language:Inglés
Published: New York, NY : Apress, [2022]
Edition:[First edition].
Subjects:
SQL server.
SQL server
Client/server computing.
Database management.
Architecture client-serveur (Informatique)
Bases de données > Gestion.
Client/server computing
Database management
Online Access:Texto completo (Requiere registro previo con correo institucional)
Table of Contents:
  • 1. Introduction to Analytic Data in a Transactional Database
  • 2. Transactional vs. Analytic Workloads
  • 3. What are Columnstore Indexes?
  • 4. Columnstore Index Architecture
  • 5. Columnstore Compression
  • 6. Columnstore Metadata
  • 7. Batch Execution
  • 8. Bulk Loading Data
  • 9. Delete and Update Operations
  • 10. Segment and Rowgroup Elimination
  • 11. Partitioning
  • 12. Non-Clustered Columnstore Indexes on Rowstore Tables
  • 13. Non-Clustered Rowstore Indexes on Columnstore Tables
  • 14. Columnstore Index Maintenance
  • 15. Columnstore Index Performance.

Similar Items