A Month of PowerShell – Day 2 (Variables and Operators)
Welcome to Day 2 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-02
1,865 reads
Wayne Sheffield
- Website: http://www.waynesheffield.com
A Month of PowerShell – Day 1 (Getting Started)
Welcome to Day 1 of my “A Month of PowerShell” series. PowerShell is one of those things that I know...
2013-02-01
2,215 reads
Adding new data files to a log shipped database
I ran into an interesting problem recently. There is a 4TB database that is log shipped to a DR site,...
2013-01-28 (first published: 2013-01-21)
1,833 reads
2013-01-15
2,376 reads
T-SQL Tuesday #38 – Standing Firm
This month’s T-SQL Tuesday is hosted by Jason Brimhall. Being as this is January, lots of people are making New...
2013-01-08
760 reads
Ghost Cleanup process
I’ve been digging deeper into the Ghost Cleanup process recently, and quite naturally my quest lead to Paul Randal’s blog....
2012-12-17
14,020 reads
TSQL Tuesday #37 – Joins and Implicit Conversions
Here we are at TSQL Tuesday #37 – the start of the fourth year. Sebastian Meine (@sqlity / blog) is hosting this...
2012-12-11
2,016 reads
T-SQL Tuesday #36 – Community
Chris Yates (@YatesSQL / blog) is hosting the T-SQL Tuesday blogging party this month, and he wants to know “What does...
2012-11-13
733 reads
Does a Clustered Index really physically store the rows in key order?
The Myth
One misconception that I see a lot deals with how data is stored in a clustered index. Specifically – is...
2012-10-21
8,168 reads
Dealing with orphaned users
The Scenario:
You just restored a production database on a development server. You’ve told the developers that it’s restored, and you...
2012-10-03
2,722 reads
Blogs
Differences Between xp_readerrolog and sp_readerrorlog: #SQLNewBlogger
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
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...
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