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 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.
With little or no knowledge of columnstore indexing you can become proficient with columnstore indexes as used in SQL Server, and apply that knowledge in development, test, and production environments. This book serves as a comprehensive guide to the use of columnstore indexes and provides definitive guidelines. You will learn when columnstore indexes should be used, and the performance gains that you can expect. You will also become familiar with best practices around architecture, implementation, and maintenance. Finally, you will know the limitations and common pitfalls to be aware of and avoid.
As analytic data can become quite large, the expense to manage it or migrate it can be high. This book shows that columnstore indexing represents an effective storage solution that saves time, money, and improves performance for any applications that use it. You will see that columnstore indexes are an effective performance solution that is included in all versions of SQL Server, with no additional costs or licensing required.

What You Will Learn

• Implement columnstore indexes in SQL Server
• Know best practices for the use and maintenance of analytic data in SQL Server
• Use metadata to fully understand the size and shape of data stored in columnstore indexes
• Employ optimal ways to load, maintain, and delete data from large analytic tables
• Know how columnstore compression saves storage, memory, and time
• Understand when a columnstore index should be used instead of a rowstore index
• Be familiar with advanced features and analytics

Who This Book Is For
Database developers, administrators, and architects who are responsible for analytic data, especially for those working with very large data sets who are looking for new ways to achieve high performance in their queries, and those with immediate or future challenges to analytic data and query performance who want a methodical and effective solution

這本書介紹了如何在SQL Server中以快速和高效的方式存儲和訪問分析數據。它展示了列存儲索引如何為存儲分析數據提供理想的解決方案，從而實現更快的分析查詢和能夠迅速提出和回答商業智能問題。該書全面介紹了列存儲索引，包括介紹、最佳實踐、實際演示、常見錯誤的解釋，並提供了適合各級專業人士的詳細架構。

即使對列存儲索引知識很少或沒有了解，您也可以熟練地使用SQL Server中的列存儲索引，並將這些知識應用於開發、測試和生產環境。該書是使用列存儲索引的全面指南，並提供明確的指導方針。您將學習何時應該使用列存儲索引以及可以期望的性能提升。您還將熟悉有關架構、實施和維護的最佳實踐。最後，您將了解限制和常見問題，並知道如何避免它們。

由於分析數據可能非常龐大，管理或遷移它的成本可能很高。這本書展示了列存儲索引是一種有效的存儲解決方案，可以節省時間、金錢並提高應用程序的性能。您將看到列存儲索引是一種有效的性能解決方案，並且在所有版本的SQL Server中都包含，無需額外的費用或許可證。

您將學到以下內容：
- 在SQL Server中實施列存儲索引
- 了解在SQL Server中使用和維護分析數據的最佳實踐
- 使用元數據充分了解存儲在列存儲索引中的數據的大小和形狀
- 使用最佳方法加載、維護和刪除大型分析表中的數據
- 了解列存儲壓縮如何節省存儲空間、內存和時間
- 理解何時應該使用列存儲索引而不是行存儲索引
- 熟悉高級功能和分析技術

本書適合數據庫開發人員、管理員和架構師，他們負責分析數據，尤其是那些處理非常大數據集並尋求在查詢中實現高性能的新方法的人，以及對分析數據和查詢性能有即時或未來挑戰的人，他們希望獲得一種有系統和有效的解決方案。