Introduction to Memory configuration
Introduction to Memory configuration Yesterday I was discussion with one of my friend on memory management and internals to expertise in...
2010-05-16
689 reads
Vinay Thakur
Audio Webcast – Whats News
Yesterday I though of doing an audio webcast what all I blog. So started audio webcast, its a series of...
2010-05-12
702 reads
Performance Tunning -Checklist
continue with performace tunning stuff, I would like to make a checklist (kind of) for general performance tunning or dba...
2010-05-06
1,122 reads
TempDB Internals
TempDB Internals: TempDB is very important DB in sql server, generally sql server automatically takes care of the storage management...
2010-05-01
1,860 reads
New Blog Location
Hi Friends.Thanx for your support. for this year onwords I will be bloging on my own website....Hope to see you...
2010-01-08
527 reads
2010-01-04
4,257 reads
2009-12-29
2,799 reads
Error Log:
Following steps happened when sql server starts… we can see that in error log::
1. Build of sql server and...
2009-12-25
665 reads
Remove Replication:
Its quite some time that I blog… but good news is I have some good stuff to blog on… so...
2009-12-16
12,463 reads
Transactional Replication Conversations –Must read
Everyone who wants to know about how transaction replication works and how to improve the performance of transaction replication must...
2009-12-03
2,146 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
VS Code, Unresolved References.
Hi all, I just started using VS Code to work with DB projects. I...
Fun with JSON II
Comments posted to this topic are about the item Fun with JSON II
Changing Data Types
Comments posted to this topic are about the item Changing Data Types
Question of the Day
Fun with JSON II
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 t1.[key] AS row,
t2.*
FROM OPENJSON(
(
SELECT t.* FROM #test_data AS t FOR JSON PATH
)
) t1
CROSS APPLY OPENJSON(t1.value) t2; See possible answers