How to convert a rowstore table to columnstore table?

Introduction In this article¬†, I introduced one of fantastic features of Microsoft COLUMNSTORE and had a comparison between a rowstore table and a columnstore table. The result was very interesting. However, if your table is in rowstore style, how we can convert a rowstore to columnstore Solution Converting a rowstore , there are two cases … Continue reading How to convert a rowstore table to columnstore table?

Advertisements

How does COLUMNSTORE INDEXES improve performance of Data Warehouse?

Introduction From SQL Server 2012, Microsoft released one of the most important features for querying a large dataset COLUMNSTORE INDEXES. The columnstore index is the standard for storing and querying large data warehousing fact tables. It uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse … Continue reading How does COLUMNSTORE INDEXES improve performance of Data Warehouse?