02864nam 2200529 450 991054818500332120221006212814.01-4842-8048-210.1007/978-1-4842-8048-59781484280485(MiAaPQ)EBC6897101(Au-PeEL)EBL6897101(CKB)21325618900041(OCoLC)1301274165(OCoLC-P)1301274165(CaSebORM)9781484280485(PPN)260832669(EXLCZ)992132561890004120221006d2022 uy 0engurcnu||||||||txtrdacontentcrdamediacrrdacarrierAnalytics optimization with columnstore indexes in Microsoft SQL Server optimizing OLAP workloads /Edward Pollack[First edition].New York, New York :Apress L. P.,[2022]©20221 online resource (285 pages) illustrationsIncludes index.Print version: Pollack, Edward Analytics Optimization with Columnstore Indexes in Microsoft SQL Server Berkeley, CA : Apress L. P.,c2022 9781484280478 Includes index.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 PerformanceMeet 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 intelligence questions with alacrity. The book provides a complete walk through of columnstore indexing that encompasses an introduction, best practices, hands-on demonstrations, explanations of common mistakes, and presents a detailed architecture that is suitable for professionals of all skill levels.Client/server computingDatabase managementClient/server computing.Database management.005.7585Pollack Edward(Database administrator),1061083MiAaPQMiAaPQMiAaPQBOOK9910548185003321Analytics Optimization with Columnstore Indexes in Microsoft SQL Server2787493UNINA