Mitigate Issues Early
When you know there's a problem, it's better to solve it early rather than late.
2018-11-28
66 reads
Editorials
Building Better Training Opportunities
Finding training opportunities can be a challenge in many organizations.
2018-11-27
63 reads
Choosing a Career
Learning about new jobs is a good way to help decide if you want to change careers.
2018-11-26
88 reads
Moving to Query Store
Steve is looking for people to use the Query Data Store and share their stories, good or bad.
2018-11-26
76 reads
A T-SQL Code Testing Guide
Testing our database code is a fairly immature process for many of this, but perhaps we could build a guide that helps everyone learn to write better and more comprehensive tests.
2018-11-23 (first published: 2014-10-07)
538 reads
2018-11-22
45 reads
Another Reason to Care About Security
Just before the US holiday, Steve wants you to think about the security of our systems.
2018-11-21
54 reads
2018-11-20
62 reads
2018-11-19
83 reads
PASS Summit 2018 Recap
This year, PASS celebrated the 20th PASS Summit. As it has been many times, this year’s Summit was held in Seattle. PASS Summit has visited other locations such as Orlando and Charlotte, but, at least to me, it feels like home when it’s hosted in Seattle. For those of us who have participated for many […]
2018-11-19
53 reads
Blogs
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...
Part 3 of 3: Tuning DiskANN — R, Alpha, L, Beam Width, Recall and Latency
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
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