Daily Coping 20 Sep 2022
Today’s coping tip is to find a caring, calming phrase to use when you feel low. Life is mostly good, but there are times I feel down, depressed, low,...
2022-09-20
12 reads
The Voice of the DBA
Daily Coping 19 Sep 2022
Today’s coping tip is to make time to remember if you’re busy, allow yourself to pause and take a break. I’m in the UK today, and at the Redgate...
2022-09-19
16 reads
Daily Coping 16 Sep 2022
Today’s coping tip is to make time to aim to be good enough, rather than perfect. I find that many of us that work in technology want a solution...
2022-09-16
20 reads
Daily Coping 15 Sep 2022
Today’s coping tip is to make time to do something you really enjoy. I do enjoy life, and I’m lucky that I have the chance to do a lot...
2022-09-15
27 reads
Daily Coping 14 Sep 2022
Today’s coping tip is to give yourself permission to say ‘no’. This is my default, and it was something I consciously made a decision to do over a decade...
2022-09-14
26 reads
T-SQL Tuesday #154–Thinking about SQL Server 2022
This month is an interesting T-SQL Tuesday party, as Glenn Berry hosts and asks us to think about the upcoming new release of SQL Server. Sometime later this year,...
2022-09-13
388 reads
Daily Coping 13 Sep 2022
Today’s coping tip is to focus on the basics today, eat healthy food, drink water, get exercise. I’m trying to make all of these a lifestyle change. In January,...
2022-09-13
22 reads
Daily Coping 12 Sep 2022
Today’s coping tip is to forgive yourself when things go wrong. A theme of being better to myself, starting with last Thur and Fri. What’s gone wrong for me?...
2022-09-12
31 reads
The Redgate 100
The Redgate 100 is a list of 100 people that are influential in the database world in a number of categories.I made the list in a few places, which...
2022-09-30 (first published: 2022-09-09)
178 reads
Daily Coping 9 Sep 2022
Today’s coping tip is to let go of self-criticism and speak to yourself kindly. This tip follows on nicely from yesterday’s tip, just the other side of that one....
2022-09-09
25 reads
Blogs
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
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...
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