PASS SQLRally Call For Speakers Update
Well, we have 3 days left in the PASS SQLRally Call for speakers and we are doing well. We have over 70 completed submissions, there may be more in a...
2010-12-13
5 reads
Jack Corbett
- Interests: Sports, books, Bible
One Week Left in the PASS SQLRally Call For Speakers
There is only one week left to submit your abstract for the PASS SQLRally. This is a great opportunity for...
2010-12-08
364 reads
Worn Out and Maybe Burned Out
Ever feel worn out and/or burned out? Don’t worry you aren’t alone. As a matter of fact most people have...
2010-12-02
585 reads
What I’m Thankful For
Since it is the week of Thanksgiving in the United States, Jason Strate (@strateSql) has requested that bloggers post what...
2010-11-24
587 reads
PASS SQLRally Call for Speakers and Registration Open!!
Call for Speakers
With the close of the PASS Summit today, the call for speakers for PASS SQLRally has opened! so...
2010-11-11
329 reads
Priorities and the PASS Summit
As most of you know, I am not attending the PASS Summit this year. I had all my plans made,...
2010-11-09
628 reads
My PASS Summit Schedule
Several bloggers have posted what their plans are for the PASS Summit and I’m following suit for 2 reasons:
So people...
2010-11-03
669 reads
T-SQL Tuesday–Why are DBA Skills Necessary?
This month T-SQL Tuesday is hosted by Paul Randal (@PaulRandal) and he asks the question, “Why are DBA Skills Necessary?”.
The...
2010-11-02
520 reads
Vote for the Pre-Con’s You’d Pay to Attend
If you read this blog you probably already know about the PASS SQLRally and that we are doing things a little...
2010-10-28
380 reads
SQLSaturday #49 – Orlando: Event Recap
SQLSaturday #49 – Orlando was this past weekend (October 16th, 2010). As one of the event organizers the entire week was...
2010-10-21
573 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