In the first PART we talked about the built-in tools in SQL Server management studio and some other custom packages scripts can help us in troubleshooting performance issues, but...
2020-09-09
35 reads
In the first PART we talked about the built-in tools in SQL Server management studio and some other custom packages scripts can help us in troubleshooting performance issues, but...
2020-09-09
9 reads
IF you are a Database administrator and managing SQL Server Database so this article for you, this article is a parent for 3 parts for How to troubleshoot the...
2020-09-09
46 reads
IF you are a Database administrator and managing SQL Server Database so this article for you, this article is a parent for 3 parts for How to troubleshoot the...
2020-09-09
4 reads
Introduction Most of us as DBA (Database administrators) have the base knowledge about the performance issues, and during our work days we faced many of performance issues, and I...
2020-09-09
36 reads
Introduction Most of us as DBA (Database administrators) have the base knowledge about the performance issues, and during our work days we faced many of performance issues, and I...
2020-09-09
10 reads
If you don’t read the previous parts you can read it from here (PART1, PART2), in this part of today we will explain how we can analyze the output...
2020-09-09
268 reads
If you don’t read the previous parts you can read it from here (PART1, PART2), in this part of today we will explain how we can analyze the output...
2020-09-09
6 reads
Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got...
2020-08-22
277 reads
Nothing Is hard when you decide to do it, from two weeks I earned my Certification of Azure Data Engineer and today I passed Exam DP-900 and I got...
2020-08-22
8 reads
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,...
Quite the title, so let me set the stage first. You have an Azure...
hi everyone I am not sure how to write the query that will produce...
Comments posted to this topic are about the item Rollback vs. Roll Forward
Comments posted to this topic are about the item Foreign Keys - Foes or...
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