pijacek.io |

10 Oct CCI – Data Loading considerations with Partitioned Tables and CCI

Posted at 10:43h in Column Store Index, Datawarehouse, Performance, SQL Server Central, SSIS by admin 0 Comments

0 Likes

Introduction In this blog post, I would like to describe two case scenarios of bulk loading data, using SSIS, into a partitioned table that has a clustered columnstore index (CCI). Let’s test the following two case scenarios: Bulk loading data from the source table directly into the...

11 Sep CCI – How to load data for better Columnstore Segment Elimination

Posted at 11:26h in Column Store Index, Datawarehouse, Performance, SQL Server Central by admin 0 Comments

0 Likes

Introduction In this blog post, I would like to explain what a columnstore segment elimination is and how to load data to achieve better segment elimination. I’ll cover the following scenarios of loading data into a CCI: Loading a Small Data Set: Create a CCI on a...