We Don't Have Perfect Information
Trying to pick the perfect schedule at a conference is fraught with issues.
2018-09-12
42 reads
Editorials
2018-09-11
95 reads
Is Forgiveness Possible?
Recently, there was a prominent film director fired from directing an episode in a very entertaining and profitable movie franchise. His firing was for tweets he made that were in very bad taste. And bad doesn’t begin to cover it, they were about topics that were universally despicable. What made this interesting was not that […]
2018-09-10
68 reads
The Hybrid Cloud
There are lots of options with cloud providers and hybrid versions of public and private clouds might be the best solution.
2018-09-10
64 reads
College Degrees Shouldn't Be Required for Tech Jobs
Today we have a guest editorial from Kendra Little that talks about the requirements you may have for potential employees.
2018-09-07
180 reads
What is the best way to on-board (train) a new junior employee?
It is important to train new people, so what is the best way to go about doing it?
2018-09-06
388 reads
Back Yourself Up
Ever thought about yourself as a resource that should be backed up to minimize your loss?
2018-09-05
124 reads
I Feel Like a Magician
Something sufficiently complex, in our eyes, may appear to be magic. Steve Jones feels some of his knowledge about SQL Server looks the same way to others.
2018-09-04 (first published: 2015-07-06)
278 reads
2018-09-03
68 reads
2018-09-03
44 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