SQL Saturday Advice - PhotoJournalism
I try to carry a camera, and a video camera, most of the time when I’m traveling. I have a...
2010-09-02
372 reads
Getting Drive Info Part 3, CLR
In the first two parts, (Part 1, Part 2), of the Getting Drive Info series the techniques to gather drive info with methods that will work on SQL Server...
2010-09-02
27 reads
Getting Drive Info Part 3, CLR
In the first two parts, (Part 1, Part 2), of the Getting Drive Info series the techniques to gather drive...
2010-09-02
1,560 reads
For SQL Server 2005/2008, Consider SecurityAdmin = SysAdmin
Note: Republishing because the article covering the issue and a workaround has been published here on SSC.
In a recent thread...
2010-09-01
4,322 reads
As a PASS Member, Don’t Forget to Vote in the 2010 PASS Board Elections
I just received my e-mail from PASS, which says, “As a PASS Member in Good Standing, you are entitled to...
2010-09-01
595 reads
Retrieving Report Names for SSRS Subscription Jobs
The way Reporting Services creates subscriptions is through generating a SQL Server Agent job. This is apparent when you look...
2010-09-01
800 reads
Naming Keys & Constraints
G'day,
This is pretty much my first blog post - at least on sqlservercentral.com - so to get started I thought that I'd...
2010-09-01
452 reads
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
The post A Stored Procedure to Move SSIS Packages...
2010-09-01
6 reads
A Stored Procedure to Move SSIS Packages Between Servers
This post provides the code for a stored procedure to move SSIS packages between SQL 2005 SSIS servers. Continue reading ?
2010-09-01
30 reads
A Stored Procedure to Move SSIS Packages Between Servers
Today’s post is one that I have been debating on whether to publish for a while. The purpose of the...
2010-09-01
991 reads
Blogs
Why sys.fn_dblog Is Undocumented And Why It's Still There
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
T-SQL Tuesday #202 SQL Server Outage You’ll Never Forget: A Roundup
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
A Last Minute Trip to the EU
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
Forums
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
Server-Level Table sizes
Comments posted to this topic are about the item Server-Level Table sizes
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