Blog – Joyful Craftsmen – The Business Intelligence Agency

CCI – Data Loading considerations with Partitioned Tables and CCI

October 10, 2018

Column Store Index, Data Warehouse, Performance, SQL Server Central, SSIS

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).…

CCI Bulk Load Pitfalls 2 – Parametrization of Dynamic SQL

September 26, 2018

Column Store Index, Data Warehouse, SQL Server Central

No Comments

Intro In the last blog I showed how important statistics are for CCI bulk load even on small tables. This time I would like to show the surprising behavior of…

CCI – How to load data for better Columnstore Segment Elimination

September 11, 2018

Column Store Index, Data Warehouse, Performance, SQL Server Central

No Comments

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…

CCI Bulk Load Pitfalls 1 – ETL Framework and up-to-date Statistics

September 3, 2018

Column Store Index, Database, Performance, SQL Server Central

No Comments

Intro I would like to start a miniseries of blogs where I try to summarize lessons learned from large data loading into clustered column store index tables (CCI). In this…

How to handle big numbers in SSAS Tabular

July 27, 2018

KB, SQL Server Central, SSAS, Tabular

No Comments

Intro Intro I have recently faced the issue of handling big numbers in SSAS Tabular. Our SSAS model processes accounting data for an international company and some amounts in the…

We are GOLD Microsoft Partners in Data Analytics!

July 3, 2018

No Comments

Joyful Craftsmen is happy to announce that we have achieved another significant milestone in our company’s history. Last week we officially became a GOLD Microsoft Partner – in the field…

CCI – Data Loading considerations with Partitioned Tables and CCI

CCI Bulk Load Pitfalls 2 – Parametrization of Dynamic SQL

CCI – How to load data for better Columnstore Segment Elimination

CCI Bulk Load Pitfalls 1 – ETL Framework and up-to-date Statistics

How to handle big numbers in SSAS Tabular

We are GOLD Microsoft Partners in Data Analytics!

About the Company

Partnership

Contacts