Analytics Optimization with Columnstore Indexes in Microsoft SQL Server : Cost-Effective, Scalable Analytics for Real-World SQL Server Workloads.

Format:

Book

Author/Creator:

Pollack, Edward.

Series:

Professional and Applied Computing Series

Language:

English

Subjects (All):

SQL server.

Client/server computing.

Database management.

Physical Description:

1 online resource (249 pages)

Edition:

2nd ed.

Place of Publication:

Berkeley, CA : Apress L. P., 2026.

Summary:

Meet the challenge of storing and accessing analytic data in SQL Server with speed and efficiency--now with expanded coverage of SQL Server 2025 and Azure SQL Database features. This updated second edition also explores how columnstore indexes compare to other modern analytic storage options, helping you make informed architectural decisions.

Contents:

Analytics Optimization with Columnstore Indexes in Microsoft SQL Server

Introduction

Acknowledgments

Table of Contents

About the Author

About the Technical Reviewer

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

16. Ordered Columnstore Indexes

Index.

Notes:

Includes index.

Description based on publisher supplied metadata and other sources.

ISBN:

9798868826108

OCLC:

1591757279