(2021-Jun-16) Recently, Google started to notify me that my blog website (http://datanrg.blogspot.com/) had been experiencing some ‘Server (5xx)’ errors. Nothing has been changed on my side, and I’m not sure how...
2021-06-23 (first published: 2021-06-16)
762 reads
2021-06-15
16 reads
2021-06-15
30 reads
For Pride this year, we’re highlighting queer nonprofits and charities. It’s more important than ever to support the queer community and raise awareness for those who do so all...
2021-06-25 (first published: 2021-06-15)
136 reads
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-06-15
14 reads
Disasters big and small happen, and as data professionals, you should be prepared for the worst! I’m thrilled to announce that we’re launching the Microsoft Data Platform Continuity Virtual...
2021-06-15
22 reads
The schedule for EightKB Summer 2021 Edition has been announced! Here’s the schedule: – N.B. – I particularly like that if you click on the session on the website,...
2021-07-02 (first published: 2021-06-15)
208 reads
I remember when I was first learning to code there was always the argument of how long a name should ... Continue reading
2021-06-30 (first published: 2021-06-15)
1,126 reads
One of the things I’ve done the last few years is collect statistics as a coach for the kids I work with. Helping them understand how they are performing...
2021-06-14
18 reads
We’re excited to welcome Day One to the Automattic team. Day One is a private journaling app that makes writing for yourself a simple pleasure. A beautifully designed user...
2021-06-14
24 reads
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
When I run my query from DW, which uses a linked server, it times...
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
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