S3OLV August Recap
The SQL Server Society of Las Vegas meeting has come and gone once again. This meeting is held typically on...
2010-08-16
446 reads
SQL RNNR
TSQL Tuesday 009 Roundup
T-SQL Tuesday #009: Beach Time
I hope you enjoyed your time in the sun with your toes in the sand. We...
2010-08-13
796 reads
Defensive Db Programming Chapter 04
This week we will be checking out the fourth chapter of this book by Alex. This is a continuous effort...
2010-08-11
753 reads
R & R
It is once again time for the blog party known as TSQL Tuesday. I am hosting this month and wanted...
2010-08-10
621 reads
August SSSOLV Reminder
Just another reminder about the Las Vegas User Group meeting coming up on August 12th.
Here is the info:
The S3OLV UG...
2010-08-10
479 reads
August S3OLV UG Meeting
It is nearly UG meeting time once again. The S3OLV UG will be meeting Thursday August 12 at 6:00. Come...
2010-08-04
489 reads
TSQL Tuesday Coming Up
The next TSQL Tuesday is only 1 week away. This month the topic covers getting a little R&R. We would...
2010-08-03
444 reads
Defensive Db Programming Chapter 03
Chapter 3 of the Defensive Database Programming Book by Alex Kuznetsov teaches us about how to “survive” changes to database...
2010-07-26
1,669 reads
5 down 4 to go
Not much ado about SQL Server here. Good things come with the number 9. For instance SQL Server got substantially...
2010-07-23
522 reads
A little Dance with SSIS and Informix
Not too many moons ago I embarked on porting some servers over from SQL 2000 to SQL 2008. On some...
2010-07-23
1,577 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