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)
635 reads
Joyful Craftsmen Blog
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)
2,625 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,479 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
148 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
242 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
498 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
395 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
313 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
75 reads
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...
2018-09-26
130 reads
Blogs
Azure Storage tips
By James-Serra
As a followup to my blog post Azure Data Lake Store Gen2 is GA,...
Managing Agent Jobs on Availability Group Servers
As always, the scripts in this post can also be found on our Git...
Permissions required for row counts to show up on Object Explorer Details
I ran into a rather obscure permissions problem the other day. Since I wasn’t...
Forums
Mirroring alerts
Hi, In one of our customers the database mirroring was already configured. After long...
On Looking and Acting the Part
Comments posted to this topic are about the item On Looking and Acting the...
How to make group by Revision_ID and when repeated display last check date separ
problem How to make group by Revision_ID and when repeated display last check date...
Ask SSC