Clustered Column Store Load Pitfalls – Magic number 64 when using WHERE IN clause

The Problem
During our workload we have recognized a difference in performance for queries using IN clause. We are building query...

Watch out – new Database Level Health Detection can send your AOAG down!

Background
In the past, Windows Server Failover Clustering (WSFC) cluster only monitored the health of your entire Always On Availability Groups...

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