Daily Coping 14 Jan 2021
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-01-14
24 reads
The Voice of the DBA
RIP Gareth Swanepoel and GoFundMe
Last week we lost another SQLFamily member. Gareth Swanepoel passed away on 8 Jan 2021. He was a fellow speaker, jolly fellow, and Microsoft PM. Across many years of...
2021-01-22 (first published: 2021-01-14)
808 reads
Security Updates for SQL Server Jan 2021–CVE-2021-1636
There was a security bulletin (CVE-2021-1636) for SQL Server, an elevation of Privilege vulnerability that could be exploited when an Extended Event session is running. SQL Server has released...
2021-01-20 (first published: 2021-01-13)
1,832 reads
Getting a New Remote Git Branch–#SQLNewBlogger
I was notified of a new PR at DataSaturdays, and I went to look at the changes. In this case, a lot of styling items in the code, which...
2021-01-29 (first published: 2021-01-13)
189 reads
T-SQL Tuesday #134–Taking a Break
I’m a day late for T-SQL Tuesday this month, literally because I was taking a break. Yesterday I took a holiday to go snowboarding with a friend. The weekend...
2021-01-13
92 reads
Daily Coping 13 Jan 2021
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-01-13
10 reads
Daily Coping 12 Jan 2021
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-01-12
20 reads
Career Goals for 2021
I’m a couple weeks late, but not nearly as late as 2020. In any case, I’m going to break these down as I did last year, but hopefully with...
2021-01-11
25 reads
Daily Coping 11 Jan 2021
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-01-11
19 reads
Goal Progress–Wrapping up 2020
This is the final look at my goals for 2020 and how I did. I am writing this a few days after the end of the year, and examining...
2021-01-08
26 reads
Blogs
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Forums
Implementing Type 4 Slowly Changing Dimensions in SQL Server
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
The Disabled Index
Comments posted to this topic are about the item The Disabled Index
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
Question of the Day
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