CCI – Data Loading considerations with Partitioned Tables and CCI

Introduction
In this blog post, I would like to describe two case scenarios of bulk loading data, using SSIS, into a...

CCI Bulk Load Pitfalls 2 – Parametrization of Dynamic SQL

Intro
In the last blog I showed how important statistics are for CCI bulk load even on small tables. This time...

CCI – How to load data for better Columnstore Segment Elimination

Introduction
In this blog post, I would like to explain what a columnstore segment elimination is and how to load data...

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

Intro
I would like to start a miniseries of blogs where I try to summarize lessons learned from large data loading...

How to handle big numbers in SSAS Tabular

Intro

Intro
I have recently faced the issue of handling big numbers in SSAS Tabular. Our SSAS model processes accounting data for...

SSAS Tabular – Fact Table Key Columns Datatype Impact

Intro
I’m working on a solution where warehouse uses string codes as the keys for dimensions. Therefore the fact table is...

DAX IF & Switch Statement Performance – Does Order Matter?

Intro
I’ve written a couple of article about IF & SWITCH in DAX over the past few years. Recently I noticed that...

SSAS Tabular – Large Dimension Performance II

What are the limits?

What are the limits?
Of course, as a follow-up to my last article you might ask at least...

SSIS script task successfully executed. Or not?

Issue
Recently we came across an interesting issue. I guess this will not happen often, but I think it’s worth mentioning...