The Non-Cluttered Index

Blog Post

Level Up!

Great news! I was accepted this weekend to speak at SQLSaturday Los Angeles! This officially counts as a level up for me for my deadlock resolution quest. The event...

2020-02-25

7 reads

Blogs

SQL Inventory Dashboards: From Raw Data to Real Insight

By

Tired of inventory headaches? Stock shortages and gluts don't just cause stress; they cost...

Free SQL Practice: 9 Killer Resources to Boost Your Query Skills

By

So, you want to get your SQL skills razor-sharp without dropping any cash? You're...

DevOps Devour Hour Slides

By

Here are the slides from my talk today at the Redgate NYC Devour Hour:...

Read the latest Blogs

Forums

CONCAT_WS

By tobias.kiehl 41317

Comments posted to this topic are about the item CONCAT_WS

Find Duplicate Rows

By JP789

What’s the best way to find duplicate rows in a sql query? I heard...

Isolation Level in Azure SQL Database

By inHouseDBA

Hello, Can you please clarify the following: In Azure SQL DB both ALLOW_SNAPSHOT_ISOLATION/READ_COMMITTED_SNAPSHOT are set...

Visit the forum

Question of the Day

CONCAT_WS

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);

See possible answers