March SSSOLV Reminder
This is just a quick reminder about the meeting coming up on March 10, 2011 at 6:30 PST. You can...
2011-03-07
468 reads
SQL RNNR
March SSSOLV Reminder
This is just a quick reminder about the meeting coming up on March 10, 2011 at 6:30 PST. You can find more information about the event from here. I...
2011-03-07
8 reads
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes....
2011-03-04
519 reads
Having Cake and Eating it Two
In early January, I wrote a little tribute to my wife for the awesome job she does when making cakes. There was a lot of good feedback from that....
2011-03-04
11 reads
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the...
2011-03-03
465 reads
Re-purpose my TableSize Script
Last Year I introduced a couple of scripts that I worked on. Those scripts developed into a series covering the comparison of some methods and MS provided stored procs...
2011-03-03
19 reads
S3OLV March 2011
The Ides of March are upon us and that means that we have another opportunity to learn some stuff about...
2011-03-02
554 reads
S3OLV March 2011
The Ides of March are upon us and that means that we have another opportunity to learn some stuff about SQL Server. We have that opportunity because it is...
2011-03-02
8 reads
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that...
2011-03-01
613 reads
Delimiting Results
Recently, I came across the need to delimit some data in order to be able to test some procedures that I was writing. The procedures need to be able...
2011-03-01
9 reads
Blogs
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Running a Local LLM On Your Laptop Resources
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
Forums
Having some performance issues with linked server query
When I run my query from DW, which uses a linked server, it times...
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
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