Paul Lambert

Blocking Chain (SQL Spackle)

Problems with blocking processes can be easy to identify with SQL Server DMV's.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.39 (23)

You rated this post out of 5. Change rating

2013-09-19

7,305 reads

The Techno Security & Digital Forensics Conference (East) runs from June 3-5, 2025, this...

You can find the slides for my session Building the €100 data warehouse with...

I’m working on an update to my Query Performance Tuning book for SQL Server...

Comments posted to this topic are about the item SQL Cookbook: Query Solutions and...

Comments posted to this topic are about the item SQL Server 2022 Query Performance...

Comments posted to this topic are about the item Architecting Power BI Solutions in...

What output do the queries produce?

SET CONCAT_NULL_YIELDS_NULL ON;
SELECT CONCAT_WS ('-', NULL, NULL);
SET CONCAT_NULL_YIELDS_NULL OFF;
SELECT CONCAT_WS ('-', NULL, NULL);