What is SQL Server not good at?
Today Steve Jones talks about some of the problems in SQL Server. Should we be documenting the situations in which features don't work well?
2013-11-21
375 reads
Editorials
It Starts with Version Control
Steve Jones knows that good development practices require lots of skill and practice, but the basis for stability with your code is version control. He talks about some reasons why you might want to implement it.
2013-11-20
432 reads
Testing Skills
How can you measure someone's DBA skills? Steve Jones comments on a new technique that someone suggested to him.
2013-11-19 (first published: 2009-05-12)
808 reads
What Counts for a DBA: Deduction
Like Sherlock Holmes, a DBA needs the sound deductive reasoning to pinpoint the root cause of a crime, in amongst a thousand interesting but irrelevant details.
2013-11-18
147 reads
Who Inspires You?
Today we have a guest editorial from Chris Shaw. After the recent PASS Summit, Chris talks about the value of getting inspired by people he listens to talking about SQL Server.
2013-11-18
140 reads
Dream Jobs
Today we have a guest editorial from Andy Warren. Andy asks today if you've thought about a dream job, and if so, what would it be?
2013-11-15
184 reads
Time for Learning
Today Steve Jones talks about the time required to increase your skills and debates about what time you need to invest each year to gain knowledge.
2013-11-14
257 reads
Runtime Code
Do you test your code? What about code that is generated by applications and executed at runtime. Is that tested well? Steve Jones wonders.
2013-11-13
138 reads
Cloud Storage. Make it the present instead of the future.
In which Phil Factor wonders why all the different cloud storage offerings are so different, sparse in their features, crude and incompatible
2013-11-11
100 reads
Cyberwar
Today Steve Jones talks about the prospect of cyberwar and the potential impacts on corporate systems. Perhaps we ought to be building better, more secure software.
2013-11-11
108 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