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
Blog Posts
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
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
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
A Time and a Place for the SQL Server Maintenance Plan Wizard
Reprinted from my editorial in Database Weekly.
In the course of my job, I get to give a lot of presentations,...
2010-01-11
374 reads
Horror… sort of
You must read this post from Tim Ford to understand why I might do this on my technical blog. But...
2010-01-11
885 reads
Kevin Cox from SQLCAT Presenting at the Denver SQL Server User’s Group On January 21, 2010
Kevin Cox, who is part of the SQLCAT Team at Microsoft, will be giving the presentation at this month’s Denver...
2010-01-11
822 reads
Lock configuration setting and preventing locking contention
The locks configuration option for SQL Server controls the number of locks available in SQL Server. You can view this...
2010-01-11
745 reads
More Laptop Issues
My laptop died on Dec 1, 2009. I was on vacation, but on Dec 2 I called Toshiba (I have...
2010-01-11
1,076 reads
New England Data Camp v2/SQL Saturdy #34 Update
The second annual New England Data Camp is shaping up to one excellent event. We’ve put together a great set...
2010-01-11
561 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