September S3OLV
Here is another short reminder about this months UG meeting in Las Vegas.
We will be meeting Thursday at the same...
2010-09-08
502 reads
SQL RNNR
Managing Contacts
This is one of those posts that has little to do with SQL Server and more to do with helping...
2010-09-06
565 reads
September S3OLV Meeting
Another month has crept up upon us. It is time once again for the Las Vegas User Group /PASS Chapter...
2010-09-03
495 reads
SQLSaturday SLC 2010
Well, I have taken another plunge. I finally got around to submitting a session for SQL Saturday Salt Lake City...
2010-09-01
518 reads
Defensive Db Programming Chapter 06
We are here again after another week and ready for another episode in this series. Today we get to talk...
2010-08-30
1,770 reads
Memory
Not a sound from the pavement
Have you ever come across a SQL query that used to run faster? Has that...
2010-08-25
3,459 reads
SSSOLV: Twitter Compliant
This is just a short blast about the Las Vegas User Group called SSSOLV (Web | Twitter). I am not certain...
2010-08-24
507 reads
Sp_whoAmI
I was doing a little catching up on some blog reading today and came across a new post from Adam...
2010-08-24
943 reads
Defensive Db Programming Chapter 05
We are here again with after another week and ready for another episode in this series. Today we get to...
2010-08-24
1,669 reads
Star Struck
Have you ever run into an error and been puzzled as to why that error occurred?
Recently I have been working...
2010-08-17
779 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