SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago...
2010-12-13
511 reads
SQL RNNR
SQL Confessions
I had a brainstorm of an idea for a group of articles on my blog a couple of weeks ago and am finally getting around to putting it together....
2010-12-13
6 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28...
2010-12-09
632 reads
Bundle of Joy
After baking for 9 months, our bouncing baby girl has finally arrived. She arrived Thursday Dec 2, 2010 at 8:28 AM (PST). There were no complications and the delivery...
2010-12-09
4 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week.
This month we will be broadcasting the...
2010-12-08
849 reads
December 2010 SSSOLV Reminder
Here is a quick reminder and a repost of the announcement from last week. This month we will be broadcasting the meeting once again. This month the technology bug...
2010-12-08
7 reads
December 2010 S3OLV Meeting
It is amazing how the months just seem to fly by these days. I probably say that every month. It...
2010-12-01
549 reads
December 2010 S3OLV Meeting
It is amazing how the months just seem to fly by these days. I probably say that every month. It seems appropriate though. This month we will be broadcasting...
2010-12-01
3 reads
Drumroll Please…
Defensive Db Programming Chapter 10
After dragging this review on for months now, it is finally time to bring this bad...
2010-11-29
1,385 reads
Drumroll Please…
Defensive Db Programming Chapter 10 After dragging this review on for months now, it is finally time to bring this bad boy home and wrap it up. I have...
2010-11-29
11 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