Introduction Recently have been working on a “Proof of Concept” task where I wanted to test the capabilities of Azure Analysis Services Tabular model when loading data from different sources (hot path and cold path) into a single table with multiple partitions. The main reason why this POC was required was the...
Introduction I recently got a call from our DBA telling me that the CPU usage is hitting 100% on the DB server and the ETL process runs for more than 24 hours, but still has not finished. You know that feeling, right? So, I connected to the...
Introduction Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that was hammering your SQL Server? I bet you wanted to get and analyse the actual runtime execution plan of this query. In this blog post, I...
Implicit Conversions – Introduction In this blog post, I’ll explain and demonstrate how to use Extended Events to detect Implicit Conversions that affect execution plans on your SQL Server instance. But before we even start with Extended Events, let’s briefly recall what an implicit conversion is,...
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...
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...