Continued thinking about my Journey blog where we have to look back at the revolutionary of SQL Server till SQL Server 2025. I would like to brief more on...
2026-03-27 (first published: 2026-03-26)
29 reads
In today’s world, this might mean something different, but in 2010, we had this value: In our context, this was about being open and transparent. This is the text...
2026-03-27
49 reads
When mirroring was first released for Azure SQL Database, it used Change Data Capture (CDC). That is still what is used to mirror SQL Server 2016 – 2022. SQL...
2026-03-25 (first published: 2026-03-11)
595 reads
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released patches for SQL Server to address privilege escalation vulnerabilities in supported versions. Time to patch!
2026-03-25 (first published: 2026-03-12)
929 reads
A while ago I blogged about a use case where a pipeline fails during debugging with a BadRequest error, even though it validates successfully. If you’re wondering, this is...
2026-03-23 (first published: 2026-03-06)
207 reads
Continuing from Day 6 we learned Embeddings, Semantic Search and Checks, on Day 7 we would learn about Vectors and Vector Databases. this is a place where AI data...
2026-03-23 (first published: 2026-03-07)
369 reads
los vidados – n. the half-remembered acquaintances you knew years ago, who you might have forgotten completely if someone hadn’t happened to mention them again – friends of friends,...
2026-03-20
28 reads
One of the things I’ve tried hard to do in database development situations if ensure I could easily refresh dev and test environments on demand. In a small startup,...
2026-03-20 (first published: 2026-03-11)
335 reads
The T-SQL Tuesday topic this month comes James Serra. What career risks have you taken? I started my career as a preacher and ended it as a director in...
2026-03-20 (first published: 2026-03-10)
418 reads
Continuing from Day 3 where we covered LLM models open/closed and their parameters, Today on Day 4 I would like to write about the Transformer architecture — the foundation...
2026-03-18 (first published: 2026-03-04)
196 reads
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
I run this code on SQL Server 2022.
CREATE TABLE Drink
(
drinkid INT NOT NULL
CONSTRAINT DrinkPK PRIMARY KEY CLUSTERED,
drinkname VARCHAR(20),
rating NUMERIC(2, 1)
)
GO
INSERT INTO Drink
(
drinkid,
drinkname,
rating
)
VALUES
(1, 'Margarita', 4.5),
(2, 'Mojito', 4.3),
(3, 'Old Fashioned', 4.7),
(4, 'Martini', 4.4),
(5, 'Cosmopolitan', 4.2)
GO
ALTER INDEX drinkpk ON dbo.drink DISABLE
GO
SELECT * FROM dbo.Drink
GO
What is the result? See possible answers