SQL Saturday Dallas Update
Just a quick update on the SQL Saturday event we are planning for the Dallas area next year. Late last...
2009-09-13
672 reads
Issue with SQL Server 2K5 SP3 CU5
In case you are considering to apply SQL Server SP3 CU5 (http://support.microsoft.com/kb/972511) to your system, I'd like to point out...
2009-09-12
1,581 reads
Meeting Sept 15th at the Microsoft Technology Center - Auditing Considerations: Native SQL 2008 and Third Party Auditing Technologies.15
Hello all!
We will be having our normal meeting at the Microsoft technology center sponsored by:
http://www.cactuss.org/Supporters/tabid/59/Default.aspx
Microsoft http://www.cactuss.org/MeetingInformation/tabid/63/Default.aspx
Stonebridge Plaza, Building One...
2009-09-12
1,028 reads
Recursion with SQL Server 2008 within the Financial World
As most of you, we in the financial world have often been faced with the challenge of extracting data from...
2009-09-12
1,385 reads
What I’ve Read and Recommend to Others – Joe Celko Edition
I’ve known Joe for a number of years and have a lot of respect for his experience and knowledge around...
2009-09-11
862 reads
Memories Of PanzerBlitz
Back when I was a small tyke, I vividly remember playing an Avalon Hill board game called PanzerBlitz, which was...
2009-09-11
1,097 reads
I like this
Not everything that can be counted counts, and not everything that counts can be counted. - Albert Einstein
from 37 signals blog.
2009-09-11
939 reads
Running a Server Side Trace
This is part two of three part series on creating, running, and scheduling Server Side Traces in SQL Server. Part...
2009-09-11
2,807 reads
LaRock on Monitoring
Since I just spent a bit more than half of my 24 Hours of PASSpresentation on tuning queries talking about...
2009-09-11
658 reads
Thanks Space Coast SQL User Group
I want to thank the Space Coast User Group for having me over to speak on the Default Trace last...
2009-09-11
367 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