2016-09-21
1,197 reads
Igor Micev
Be a good administrator
Below are the topics every Administrator has to keep up with.
Backup / Restore:
Understand the backup / restore options SQL Server provides for...
2016-09-19
182 reads
Be a good administrator
Administering SQL ServerBelow are the topics every Administrator has to keep up with.Backup / Restore:Understand the backup / restore options SQL Server...
2016-09-19
183 reads
Be a good administrator
Below are the topics every Administrator has to keep up with. Backup / Restore: Understand the backup / restore options SQL Server provides for you. Implement those on your...
2016-09-19
6 reads
Be a good administrator
Below are the topics every Administrator has to keep up with. Backup / Restore: Understand the backup / restore options SQL Server provides for you. Implement those on your...
2016-09-19
5 reads
Target Recovery Interval and Indirect Checkpoint
Indirect checkpoint is the recommended configuration, especially on systems with large memory footprints and default for databases created in SQL Server 2016.
2016-07-21
10,970 reads
Target Recovery Interval and Indirect Checkpoint
Introduction
The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process....
2016-07-12
296 reads
Target Recovery Interval and Indirect Checkpoint
IntroductionThe process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process....
2016-07-12
557 reads
Target Recovery Interval and Indirect Checkpoint
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log...
2016-07-12
48 reads
Target Recovery Interval and Indirect Checkpoint
Introduction The process that writes the dirty pages from the system memory (RAM) to the disk is called the checkpoint process. Dirty pages consist of the data and log...
2016-07-12
6 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
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
Foreign Keys - Foes or Friend?
Comments posted to this topic are about the item Foreign Keys - Foes or...
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