SSAS Tabular – Process Add memory consumption
For me it’s a bit surprising how little information can be found regarding the “Process Add” option which I consider as the best choice for incremental data load to...
2020-01-23
58 reads
Joyful Craftsmen Blog
Query Performance Tuning with Filtered Statistics
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)
683 reads
How to get Live Execution Plan using Extended Events
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)
6,680 reads
Extended Events: Detect Implicit Conversions that affect execution plans
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,825 reads
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...
2018-12-18
169 reads
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...
2018-11-20
288 reads
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....
2018-11-05
630 reads
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...
2018-10-23
414 reads
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...
2018-10-16
862 reads
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...
2018-10-10
263 reads
Blogs
From Data Custodian to Innovation Catalyst: The Evolving Role of the CDO
By Chris Yates
There was a time when the Chief Data Officer lived in the shadows of...
Down the Rabbit Hole: Dealing with Ad-Hoc Data Requests
By Rayis Imayev
"But I don’t want to go among mad people," Alice remarked."Oh, you can’t help...
Adding a Local Model to Ollama through the GUI
By Steve Jones
I saw some good reviews of the small gemma3 model in a few places...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques
Comments posted to this topic are about the item SQL Server Advanced Troubleshooting and...
T-SQL Fundamentals
Comments posted to this topic are about the item T-SQL Fundamentals