Thanks to everyone who joined the blog party this month. I noticed three themes in the responses. Every response had one or more of these themes woven into their...
2026-04-17
32 reads
Every organization I talk to has the same problem dressed up in different clothes. Somewhere in the business, a decision maker is sitting on a question that the data...
2026-04-17 (first published: 2026-04-07)
334 reads
Learning any kind of theory is easy, but adapting FinOps and watching it rescue a chaotic cloud environment is where it gets interesting. FinOps is about building a culture...
2026-04-15 (first published: 2026-04-06)
1,015 reads
I saw a question asking about the next sequence value and decided to try and answer it myself. I assumed this would be easy, and it was, but I...
2026-04-15 (first published: 2026-03-30)
194 reads
Once your Fabric tenant grows past a few workspaces, data discovery gets weird fast. Duplicates multiply. People stop trusting what they find. And security teams start hearing things like,...
2026-04-14
40 reads
As a data nerd who’s spent the last 25+ years helping organizations keep their databases running smoothly, I’ve had this conversation more times than I can count: “We’re moving...
2026-04-14
46 reads
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard Edition, a few on the Enterprise Edition, and others handling core work, like the Linux/PostgreSQL...
2026-04-13 (first published: 2026-04-06)
210 reads
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE which is introduced on SQL Server 2008, TDE is at rest has limitation as data...
2026-04-13 (first published: 2026-04-04)
286 reads
The greatest rewards come from working on something that nobody has words for. If you possibly can, work where there are no names for what you do.” – from...
2026-04-10
34 reads
I have a presentation on finding balance in your career that got quite a few people thinking and commenting on their own experiences. I decided to write a few...
2026-04-10 (first published: 2026-04-01)
201 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