Columnar storage brings a completely new set of possibilities to SQL Server. You can get lightning performance in analytical queries right from your data warehouse, without a special analytical database management system. This chapter started by describing features that support analytical queries in SQL Server other than columnar storage. You can use row or page data compression levels, bitmap filtered hash joins, filtered indexes, indexed views, window analytical and aggregate functions, table partitioning, and more. However, columnar storage adds an additional level of compression and performance boost. You learned about the algorithms behind the fantastic compression delivered by columnar storage. This chapter also included a lot ...
Summary
Get SQL Server 2017 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
