Webcast Tomorrow - Dynamic SSIS: Using Expressions and Configurations
Join me tomorrow at 1:00pm CST as I present "Dynamic SSIS: Using Expressions and Configurations" for the PASS DBA virtual...
2010-01-12
1,028 reads
TSQL Tuesday #2
I’ve wracked my brain for some bit of puzzle that I could present as part of TSQL Tuesday #2 and I...
2010-01-12
1,128 reads
IN vs INNER JOIN
Often in forum threads discussing query performance I’ll see people recommending replacing an INNER JOIN with an IN (or recommending...
2010-01-12
21,706 reads
We Interrupt Your Regular SQL Blogging For This Announcement…
EXEC sys.sp_addextendedproperty
@name = N'IsWifePregnant',
@value = N'True',
@level0type = N'USER',
@level0name = N'Kendal.VanDyke' ;
EXEC sys.sp_addextendedproperty
@name = N'ExpectedDueDate',
@value = N'August 2010',
@level0type = N'USER',
@level0name...
2010-01-12
799 reads
Setting Goals for 2010
Most people set their New Year resolutions for the new year at this time. We know from history that many...
2010-01-12
362 reads
Would Third-party Product Driven/Vendor Sessions Benefit User Groups and Community Events?
In the the couple of years I have been involved in the SQL Server community I have noticed that there...
2010-01-12
790 reads
Video Featured on SQLShare
I didn’t have a chance to blog this yesterday (January 11, 2010), but my most recent video, Dynamic SQL Using...
2010-01-12
479 reads
T-SQL Tuesday #2 – Data Conversions
Adam Machanic started the idea of a blog party last month, getting people to write about date and time issues...
2010-01-12
1,695 reads
January OPASS Meeting Tonight
Tonight is the January meeting for OPASS and we have a great schedule for the evening.
Robert Hurwitz a developer for...
2010-01-12
389 reads
T-SQL Tuesday #2 – Data Conversions
Adam Machanic started the idea of a blog party last month, getting people to write about date and time issues...
2010-01-12
525 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