15 years of experience with Identity columns
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,051 reads
Blog Posts
A Sherlockian Question Of the Day & Why I’m Writing Questions
If you haven’t noticed by now I’ve been writing quite a few questions of the day for SQLServerCentral. It started,...
2014-06-04
332 reads
How Does Disabling an Index Affect the Index Usage DMV Counters
A question was posted to #SQLHelp on Twitter asking, if disabling an Index would clear the index usage counters stored in the...
2014-06-04 (first published: 2014-05-28)
1,998 reads
Miscellaneous Notes on the PASS NomCom and General Election
Interesting day yesterday. A spirited discussion on Twitter, a challenging post from candidate Mark Broadbent, and a couple good threads...
2014-06-04
647 reads
Upcoming SQL Saturdays & Precons
This coming weekend is the SQL Saturday #307 in Iowa City, Iowa. I am really looking forward to attending this event...
2014-06-04
455 reads
Using PIVOT function without a CTE
There are some cases when you need to use a PIVOT function in SQL but you cannot use a CTE....
2014-06-04
1,250 reads
Access Granted or Not? Question of the Day
Access Granted or Not? is my latest Question Of The Day and I think it represents a pretty good troubleshooting...
2014-06-03
473 reads
Attaching All Databases with PowerShell–Attaching Missing Databases
I wrote a PowerShell script recently to actually accomplish a task I that I needed. What’s more, this was the...
2014-06-03
1,285 reads
Busy Busy Weeks, Finally Some Good News! SQL 2008 / 2008 R2 Will Get Their Final Service Pack!
We will actually be getting our final Service Pack!
The information can be found here. You may still want extended support...
2014-06-03
655 reads
Columnstore Memory Grant Issue
In a previous post about non-clustered columnstore indexes, I mentioned the creation of an index is a very memory intensive...
2014-06-03
2,182 reads
Blogs
AI: Blog a Day – Day 5: Notebooks, Hugging face models and Fine Tuning
By Vinay Thakur
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we...
AI: Blog a Day – Day 4: Transformers – Encoder, Decoder, and Attention
By Vinay Thakur
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today...
Flyway Tips: Multiple Projects
By Steve Jones
One of the nice things about Flyway Desktop is that it helps you manage...
Forums
Can an Azure App Service Managed Identity be used for SQL Login?
I'm fairly certain I know the answer to this from digging into it yesterday,...
Azure Synapse database refresh
Hi Team, I am trying to refresh the Azure Synapse Dedicated pool from production...
how to write this query?
hi everyone I am not sure how to write the query that will produce...
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