Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
2010-08-27
4,181 reads
Jason Brimhall
Memory
Not a sound from the pavement
Have you ever come across a SQL query that used to run faster? Has that...
2010-08-25
3,413 reads
Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
2010-08-24
1,665 reads
Sp_whoAmI
I was doing a little catching up on some blog reading today and came across a new post from Adam...
2010-08-24
930 reads
SSSOLV: Twitter Compliant
This is just a short blast about the Las Vegas User Group called SSSOLV (Web | Twitter). I am not certain...
2010-08-24
503 reads
Star Struck
Have you ever run into an error and been puzzled as to why that error occurred?
Recently I have been working...
2010-08-17
770 reads
S3OLV August Recap
The SQL Server Society of Las Vegas meeting has come and gone once again. This meeting is held typically on...
2010-08-16
432 reads
TSQL Tuesday 009 Roundup
T-SQL Tuesday #009: Beach Time
I hope you enjoyed your time in the sun with your toes in the sand. We...
2010-08-13
793 reads
Defensive Db Programming Chapter 04
This week we will be checking out the fourth chapter of this book by Alex. This is a continuous effort...
2010-08-11
743 reads
August SSSOLV Reminder
Just another reminder about the Las Vegas User Group meeting coming up on August 12th.
Here is the info:
The S3OLV UG...
2010-08-10
468 reads
Blogs
What DevOps Look Like in Microsoft Fabric
By HeyMo0sh
Microsoft Fabric (not to be confused with the more general term “fabric” in DevOps)...
T-SQL Tuesday #192: What career risks have you taken?
By James Serra
I’m honored to be hosting T-SQL Tuesday — edition #192. For those who may...
AI: Blog a Day – Day 3: LLM Models – Open Source vs Closed Source
By Vinay Thakur
Continuing from Day 2 , we learned introduction on Generative AI and Agentic AI,...
Forums
Ready to launch your next big game?
Looking for a creative and experienced mobile game development company that brings your game...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
Rollback vs. Roll Forward
Comments posted to this topic are about the item Rollback vs. Roll Forward
Question of the Day
Fun with JSON I
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