Negotiating - It's Not All About Winning
More and more I see business people adopt the mindset that any negotiation is raw combat with the goal of...
2008-08-05
607 reads
More and more I see business people adopt the mindset that any negotiation is raw combat with the goal of...
2008-08-05
607 reads
One of the common questions new SQL Server workers ask is how they can move or alter tempdb. Andy Warren takes a look at the tricks involved with this special system database.
2008-08-04
6,377 reads
Moving Tempdb isn't a common operation, and mercifully a simple one if it comes to that. As in much of...
2008-08-04
297 reads
I'm probably in the minority, but I use an offline reader for consuming feeds. Nothing wrong with browser based readers other than that...
2008-08-04
253 reads
We've got two technical sessions scheduled for tomorrow night. The first is by long time oPASS member Dolores Tofel discussing...
2008-08-03
320 reads
SQLSaturday #5 in Olympia is progressing nicely. 85 registered, venue locked in, and work under way for fund raising via...
2008-08-01
558 reads
Maybe I haven't looked at the right products, but two years ago when we needed a VPN solution there wasn't...
2008-07-31
1,451 reads
Recently my friend Steve (managing editor of SSC) posted to his blog about The Bad Karma Project that has to...
2008-07-30
1,369 reads
Recently I was driving home and as I made that turn into the sub-division where I live, over the course...
2008-07-30
1,355 reads
Are you rebuilding statistics twice on your tables? Longtime expert, Andy Warren, shows why you might be asking more work of your SQL Server than is required.
2008-07-29
9,161 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,...
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
Looking for a creative and experienced mobile game development company that brings your game...
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