Learn How to Use the SQL Server 2008 Transact-SQL Debugger
Bill Ramos, a SQL Server Product Manager, has written a three part series on how to use the SQL Server...
2009-04-15
857 reads
Bill Ramos, a SQL Server Product Manager, has written a three part series on how to use the SQL Server...
2009-04-15
857 reads
Microsoft has finally updated their classis Troubleshooting SQL Server Performance white paper for SQL Server 2008, which is available at:
Troubleshooting...
2009-04-15
1,244 reads
The Portland Code Camp will be held at Reed College on Saturday, May 30, 2009. This free event will include...
2009-04-15
420 reads
The Richmond Code Camp 2009.1, will be held on Saturday 25, 2009 at the J. Sargeant Reynolds Community College in...
2009-04-15
636 reads
If you have been procrastinating about submitting a speaking abstract for the 2009 PASS Community Summit, you have been given...
2009-04-08
546 reads
If you have already submitted an abstract for the 2009 PASS Community Summit, or you are still thinking about it,...
2009-04-02
658 reads
The advent of social networking has excited many DBAs, but is that a good thing? Does social networking help or hurt you in your career?
2009-03-30
174 reads
SQLBits IV was held in Manchester, England, Saturday March 28th, 2009, and was attended by more than 360 attendees. This...
2009-03-29
2,100 reads
As most of you know now, the Call for Speakers for the 2009 PASS Community Summit is open from March...
2009-03-24
967 reads
This year, I was asked to participate on the PASS Program Committee Management team as the “Speaker Manager.” One of my tasks is to create a Speaker’s Resource page on the SQLPASS.org website to aid speakers who want to submit session abstracts for the 2009 PASS Summit, which will be held in Seattle, WA from November 3 — 6, 2009.
2009-03-17
1,157 reads
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
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