Failed Installation of SQL Server Cumulative Updates Debugged

Background
Our customer has recently experienced an issue during the installation of the latest cumulative updates in their SQL Server environment....

DAX – Cumulative Total and Blank Handling

When developing DAX measure, you should be aware that Blank value behavior might be similarly insidious as NULL value in...

Internal Query Processor Error Debugged

In Joyful Craftsmen we provide, among other things, technical support to our customers, which from time to time involves us...

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