Deleting a Git Branch–#SQLNewBlogger
I had someone ask me recently about deleting branches. While I had known how to delete a local branch, I had to look up how to delete a remote...
2023-11-03 (first published: 2023-10-23)
191 reads
The Voice of the DBA
The Year in Travel
Here’s my year, which is pre-populated with a couple more trips coming up in November. Those should be all, as I’ve declined to go back to the UK in...
2023-10-20
29 reads
A New Word: Gobo
gobo – n. the delerium of having spent all day in an aesthetic frame of mind, taking photos across the city, getting lost in an art museum – which...
2023-10-20
36 reads
Creating a SQL Clone Image from a SQL Clone Database
A customer asked if a new image could be created from a database that was itself a SQL Clone. It can, and I’ll show that in this post. This...
2023-10-27 (first published: 2023-10-16)
228 reads
SQL Saturday Boston 2023 Slide Decks
Thanks to everyone who came to my sessions at SQL Saturday Boston 2023. I’ve added the decks to the schedule, so you can click my session and will see...
2023-10-14
63 reads
A New Word: Harmonoia
harmonoia – n. an itchy sense of dread when life feels just a hint too peaceful – when everyone seems to get along suspiciously well, with an eerie stillness...
2023-10-13
51 reads
An Important Break
I left home last Tuesday for work, heading to New Jersey for work. Over the weekend, I took a side trip to see my daughter play volleyball at university,...
2023-10-09
45 reads
The Database DevOps Roadshow Continues (with fun photos)
At SQL Saturday Denver 2023, I had a few people ask me about the Redgate Database DevOps roadshow and how it was going. A few people asked about the...
2023-10-06
69 reads
A New Word: Ringlorn
ringlorn – adj. the wish that the modern world felt as epic as one depicted in old stories and folktales – a place of tragedy and transcendence, of oaths...
2023-10-06
136 reads
Speaking at SQL Saturday Boston 2023
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to this event last year and I’m glad to be going again. It’s a great event,...
2023-10-03
27 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