Joyful Craftsmen Blog

Query Performance Tuning with Filtered Statistics

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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

2019-09-04 (first published: 2019-08-26)

622 reads

How to get Live Execution Plan using Extended Events

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

Introduction
Have you ever found yourself in a situation where you were supposed to troubleshoot a long running expensive query that...

2019-03-06 (first published: 2019-02-19)

2,528 reads

Extended Events: Detect Implicit Conversions that affect execution plans

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

Implicit Conversions – Introduction
In this blog post, I’ll explain and demonstrate how to use Extended Events to detect Implicit Conversions that...

2019-01-24 (first published: 2019-01-15)

2,471 reads

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

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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

2018-12-18

148 reads

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

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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

2018-11-20

239 reads

Failed Installation of SQL Server Cumulative Updates Debugged

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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

2018-11-05

496 reads

DAX – Cumulative Total and Blank Handling

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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

2018-10-23

395 reads

Internal Query Processor Error Debugged

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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

2018-10-16

304 reads

CCI – Data Loading considerations with Partitioned Tables and CCI

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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

2018-10-10

74 reads

CCI Bulk Load Pitfalls 2 – Parametrization of Dynamic SQL

• by Joyful-Craftsmen

• Joyful Craftsmen Blog

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

2018-09-26

130 reads