Joyful Crafsmen is a young company designing, constructing and operating business intelligence solutions for enterprises. People behind are experts in Microsoft Data Platform, which includes SQL Server, Microsoft Azure, Power BI and other leading edge Microsoft technologies. Sharing our know-how with others is our other love. Through training, consulting, and teaching in our community, we help others to be better and better every day.

All authors

All authors

Blogs

Creating a Striped Backup Set with AI

By

I needed to test a striped backup, so I decided to ask the AI’s...

SQL Server Migration Overview

By

It’s Not Just Backup / Restore At some point every company faces it: the...

Trace Flag 1448 – Lessons from a Technical Interview

By

In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...

Read the latest Blogs

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

By Nisarg Upadhyay

Comments posted to this topic are about the item Create an HTML Report on...

Can/Can't Do/Don't

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Can/Can't Do/Don't

Strange String Splits

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Strange String Splits

Visit the forum

Question of the Day

Strange String Splits

When I run this code, how many rows are returned? 

DECLARE @meals NVARCHAR(1000) = N'夕食昼食朝食'
DECLARE @s NVARCHAR(1) = N'食'
SELECT value
FROM STRING_SPLIT(@meals, @s)
GO

See possible answers