I am humbled that many posts were submitted for T-SQL Tuesday #157. There is such a wide range of plans to wind down 2022. So enjoy the posts below...
2022-12-30 (first published: 2022-12-20)
260 reads
Today’s coping tip is to do something helpful for a friend or family member. Easy one for me. My daughter came home from University yesterday, and I took time...
2022-12-20
22 reads
SAVE THE DATE: VMUG Ireland Relaunch Event February 9th, 2023 Location: Dublin VMUG Ireland is back! We are hosting a VMUG Relaunch event in Dublin on February 9th, 2023....
2022-12-20
30 reads
This post introduces you to the Pure Storage FlashArray OpenMetrics Exporter. It shows you how to get started quickly using Docker Compose so you can monitor your Pure Storage...
2023-01-04 (first published: 2022-12-20)
346 reads
TDE is referred to as a “transparent” form of encryption. What that means is that the process of encrypting and decrypting data is fully performed in the background. The...
2022-12-19
115 reads
Today’s coping tip is to give kind comments to as many people as possible today. Not an easy tip for me to follow as I’ve been a little home...
2022-12-19
23 reads
Watch this week's video on YouTube
How do you keep track of your daily work accomplishments?
If you are like me, you wait until the end of the week and then...
2022-12-19
21 reads
Watch this week's video on YouTube
How do you keep track of your daily work accomplishments?
If you are like me, you wait until the end of the week and then...
2022-12-19
34 reads
Recently a customer was trying to sync up production and development. They’d somewhat lost control of both environments and wanted to build a plan of how to sync them....
2022-12-30 (first published: 2022-12-19)
350 reads
Today’s coping tip is to send a gift to someone new. I have been sending gifts to my daughter at college every month or so, but I decided I...
2022-12-16
30 reads
When I put together the invitation for T-SQL Tuesday #202, I wasn't sure what...
By Steve Jones
My life has some crazy travel stretches for sure. Between speaking, office visits, customer...
In Part 1, we saw how ‘Vamana’ represents vectors as nodes, connects them with...
Comments posted to this topic are about the item Implementing Type 4 Slowly Changing...
Comments posted to this topic are about the item The Disabled Index
Comments posted to this topic are about the item Server-Level Table sizes
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