Faster
In the human history, there was a huge drive (such an ambiguous meaning here) to get faster.
Maybe within our DNA...
2018-01-19
306 reads
Niko Neugebauer
- Website: http://www.nikoport.com
Jack of ALL Trades
Warning: If during reading this post, you feel like a lot of bells started ringing – I might have written about...
2018-01-18
399 reads
Columnstore Indexes – part 118 (“SQL Server 2017 Editions Limitations”)
Continuation from the previous 117 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
As a logical continuation from the blog...
2018-01-05
858 reads
Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)
Continuation from the previous 116 parts, the whole series can be found at http://www.nikoport.com/columnstore/
An important issue I have faced already...
2017-12-29
1,000 reads
Presentations & Blogging of 2017 in Review
And here comes the 5th time I am reviewing what happened on the presentation an blogging side of my life,...
2017-12-29
601 reads
Columnstore Indexes – part 116 (“Partitioning Specifics”)
Continuation from the previous 115 parts, the whole series can be found at http://www.nikoport.com/columnstore/
After delaying for a couple of years...
2017-12-28
510 reads
Precon at SQLKonferenz 2018
One of my favourite conferences (and so far I was incredibly lucky to have spoken at every edition) is SQLKonferenz,...
2017-12-27
351 reads
Columnstore Indexes – part 115 (“Bulk Load API and Pressure”)
Continuation from the previous 114 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post is dedicated to the...
2017-11-08
397 reads
Columnstore Indexes – part 114 (“Machine Learning Services”)
Continuation from the previous 113 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blogpost is focusing on the unsung...
2017-10-29
712 reads
Columnstore Indexes – part 113 (“Row Groups Merging Limitations”)
Continuation from the previous 112 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
This blog post serves as the continuation...
2017-09-24
430 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