In my recent blog post, Building Power BI Reports: Desktop vs Fabric, I talked about the evolving authoring experience in Microsoft Fabric and how report development is increasingly moving...
2026-03-09
72 reads
I wrote about TempDB Internals and understand that Tempdb plays very important role on SQL Server performance and everything temporary / memory spill comes to tempdb and it is...
2026-03-09 (first published: 2026-03-02)
510 reads
As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out of control without the right practices in place. That’s where FinOps comes in—it’s a powerful...
2026-03-09
26 reads
In 100 years a lot of what we take to be true now will be proved to be wrong, maybe even embarrassingly wrong. A good question to ask yourself...
2026-03-06 (first published: 2026-02-20)
604 reads
This is kind of a funny page to look at. The next page has more detail. This is the text from the facing page: What we do is very...
2026-03-06
43 reads
As someone who’s worked with data for over 20 years and with many cloud platforms, my main focus has always been on helping teams streamline their development process. A...
2026-03-06 (first published: 2026-03-02)
623 reads
Continuing from Day 4 where we learned Encoder, Decoder, and Attention Mechanism, today we will discuss more on different free notebooks available to write / code LLM and get...
2026-03-05
30 reads
I’m a big fan of the “instantclient” solution to Oracle connectivity. No more calls to “runInstaller”, no registry files on Windows, it is just download-unzip-go. That makes installation a...
2026-03-05
39 reads
You could be tolerating limited reporting because there isn’t an off the shelf solution that meets your needs and you’re scared about the costs of a fully bespoke reporting...
2026-03-04 (first published: 2026-02-22)
384 reads
2025 belongs to the AI startups. If you peek into the tech headlines, you’ll see companies like OpenAI, Anthropic, Gemini, Lovable, and Poolside AI dominating the conversation. Different names,...
2026-03-03 (first published: 2026-03-02)
41 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