Suggestions for PASS Published on SSC
I wrote this article shortly after returning from the PASS 2007 Summit and tried hard to come up with ideas...
2007-10-18
1,349 reads
I wrote this article shortly after returning from the PASS 2007 Summit and tried hard to come up with ideas...
2007-10-18
1,349 reads
All of these are new articles that have gone up on SSC recently. The troubleshooting one was my attempt to...
2007-10-14
628 reads
Bill Graziano (main man at SQLTeam.com, consultant, and VP of PASS) was in town recently to speak at both the...
2007-10-13
683 reads
I'm catching up on my reading today and ran across an article from Kathi Kellenberger called Understanding the Difference between...
2007-10-13
604 reads
I'm a couple days late updating the blog, the article went up on Mon.
2007-10-11
572 reads
Continuing on with a look at SQL Server 205 partitioning features, Andy Warren delves into archiving techniques.
2007-10-08
9,126 reads
I spent last week onsite with a client teaching performance tuning and it was really a good week. Great company...
2007-10-08
607 reads
SQL Server guru Andy Warren brings us a list of things that he considers when things go wrong. Read about some of the common sense approaches to solving performance and other problems.
2007-10-03
4,595 reads
This article by Andy warren shows you how to get started with DMO using either VB or VBScript. The article includes sample code that will backup all databases on a server and will update the statistics on all databases as well.
2007-10-02 (first published: 2003-08-15)
39,128 reads
This article by Andy Warren talks about using sp_addlogin to move logins from one server to another. It also points out a problem you may run into if you have a SQL 7 server that was upgraded from 6.5
2007-10-02 (first published: 2001-05-01)
10,935 reads
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...
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
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