AI Experiments–Who am I and how am I remembered?
I saw someone noting that AIs shouldn’t write obituaries. Since I maintain sqlmemorial.org, I wanted to see what would happen for me. This is part of a series of...
2023-05-16
33 reads
The Voice of the DBA
Leveling Up for Sales and Marketing
I’m heading to Austin today for Redgate’s internal Level Up conference. This is designed to help employees improve their skills in some way. The original ones focused on technology...
2023-05-15
52 reads
A New Word: Vemödalen
vemoödalen – the fear that originality is no longer possible I used to worry about this, and often I thought that I’d run out of original things to do....
2023-05-12
107 reads
What Backups Are In This File?–#SQLNewBlogger
I had a question on multiple backups in a file and had to check my syntax. This post shows how to see which backups are in a file. Note:...
2023-05-24 (first published: 2023-05-10)
150 reads
Traveling to SQL Saturday Jacksonville 2023
I’m heading to SQL Saturday Jacksonville 2023 today, speaking tomorrow. After not making any of their events, I went in 2022 and am back for their 15th event this...
2023-05-05
35 reads
A New Word: Chysalism
Chysalism – n. the amniotic tranquility of being indoors during a thunderstorm? While I love the sun, I did enjoy thunderstorms when I lived in Virginia. Something neat about...
2023-05-05
42 reads
Experiments with GitHub CoPilot
There has been a lot of attention given to ChatGPT and AI over the last month or two. I’ve tried a few things with the public interface at Open.ai....
2023-05-12 (first published: 2023-05-03)
629 reads
Why Learn PostgreSQL?
At Redgate, we’ve spent a lot of time adding PostgreSQL functionality to our DevOps tools. We’ve also hired an advocate, Ryan Booz, to help us spread the word and...
2023-04-26
317 reads
Exporting SQL Data Compare Results to Excel
I had someone ask recently about getting SQL Data Compare results in Excel. It’s easy to do and this post looks at the process. Exporting a Comparison I won’t...
2023-05-05 (first published: 2023-04-25)
161 reads
Flyway Desktop PoC–Adding a Shadow and Baseline Script
In the last post, I created a baseline marker for Flyway in each database. This set the version in the dev and QA databases to v1. However, I also...
2023-04-12
52 reads
Blogs
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...
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...
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