Goal Progress for Feb 2023
The grade for February is also D. Details below, but just not making a lot of progress in these areas. So far I have: Jan – D Feb –...
2023-03-03
44 reads
The Voice of the DBA
Daily Coping 3 Mar 2023
Today’s coping tip is to send an encouraging note to someone who needs a boost. I met someone at a conference years ago and kept in touch. For some...
2023-03-03
32 reads
Daily Coping 2 Mar 2023
Today’s coping tip is to make plans with a friend or loved one. I don’t like making plans, preferring to somewhat flow with life and make decisions close to...
2023-03-02
24 reads
Shutting Down Coping Tips
It’s been nearly 3 years of Daily Coping Tips here at the Voice of the DBA. I started these when the pandemic hit and the world shut down. I’ve...
2023-03-01
40 reads
Adding a Computed Column–#SQLNewBlogger
Recently I needed to add a computed column to a table and realized that I didn’t remember the syntax. This short post show how to do this. Another post...
2023-03-10 (first published: 2023-03-01)
483 reads
Daily Coping 1 Mar 2023
Today’s coping tip is to call a friend to catch up and really listen to them Actually a friend pinged me to ask about a call recently. I made...
2023-03-01
20 reads
Daily Coping 28 Feb 2023
Today’s coping tip is to thank three people you feel grateful to and tell them why. This is something I tend to do privately, thanking people who’ve impacted my...
2023-02-28
16 reads
A Corporate Wellness Day
Today is the corporate Wellness Day at Redgate. It’s a day off for almost everyone in the company, unless they have something that can’t get moved. A few support...
2023-02-27
84 reads
Daily Coping 27 Feb 2023
Today’s coping tip is to tell a loved one about the strengths you see in them. For one of my kids, I’m letting them know that I see: responsibility...
2023-02-27
23 reads
Daily Coping 24 Feb 2023
Today’s coping tip is to be gentle with someone you feel inclined to criticize. It’s very easy, and maybe very human, to start to criticize others for doing something...
2023-02-24
22 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