Tag Archives: Compression

Clustered Columnstore Index in SQL Server 2014

The clustered columnstore index which shipped with SQL Server 2014 is busy revolutionizing the Data Warehousing landscape in SQL Server. When creating a Fact Table in a data warehouse you will almost without question put a Clustered Columnstore (CCI) on … Continue reading

Posted in SQL Server 2014 | Tagged , , , | Leave a comment

Impact of page compression on data warehouse loads

As a data warehouse professional you are faced with some trade-offs. One of them is speed versus space. The article below shares some interesting facts about applying compression to tables. It indicates the affect page compression has on bulk load … Continue reading

Posted in SQL Server 2014 | Tagged , | Leave a comment