I recently found this DMV and couldn’t wait to share. sys.dm_server_services What’s so great about it? For each service for ... Continue reading
2019-09-23 (first published: 2019-09-12)
1,025 reads
It’s fantasy football time again? Oh, fantasy feature? Oh, yea, that makes a lot more sense for #tsql2sday. What’s #tsql2sday? ... Continue reading
2019-09-19 (first published: 2019-09-10)
525 reads
When studying Azure one of the things you’ll be asked to learn is the Powershell commands that can control, well, ... Continue reading
2019-09-18
78 reads
If you can help it you probably shouldn’t be using triggers. But if you have to use a trigger you ... Continue reading
2019-09-09 (first published: 2019-08-26)
534 reads
TL;DR; Final query is at the bottom. Every now and again (particularly when someone is having performance problems) I’ll get ... Continue reading
2019-09-04
199 reads
Everything else aside two of the most important tasks of a database are to get data in, and get data ... Continue reading
2019-09-02
243 reads
If you started out as a developer you were probably taught how important loops are. They are one of the ... Continue reading
2019-09-02 (first published: 2019-08-22)
1,224 reads
I recently had someone tell me, and I’m paraphrasing a bit here: We know how to fix this now, so ... Continue reading
2019-08-28
159 reads
Occasionally I’ve seen date and time stored separately as integers. This had some practical applications back before we had date ... Continue reading
2019-08-27 (first published: 2019-08-15)
789 reads
tl;dr; Temporary stored procedures are excellent for testing pieces of code that are going to go into (or come from) ... Continue reading
2019-08-21 (first published: 2019-08-07)
914 reads
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
I'm fairly certain I know the answer to this from digging into it yesterday,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
hi everyone I am not sure how to write the query that will produce...
I have some data in a table:
CREATE TABLE #test_data
(
id INT PRIMARY KEY,
name VARCHAR(100),
birth_date DATE
);
-- Step 2: Insert rows
INSERT INTO #test_data
VALUES
(1, 'Olivia', '2025-01-05'),
(2, 'Emma', '2025-03-02'),
(3, 'Liam', '2025-11-15'),
(4, 'Noah', '2025-12-22');
If I run this query, how many rows are returned?
SELECT *
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t; See possible answers