I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.
In this episode I share...
2020-07-27 (first published: 2020-07-16)
955 reads
Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is our smaller, focused sessions. This one is about the concept of how DevOps, or, more...
2020-07-16
47 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-16
10 reads
For the better part of 15 years, SQL Server Integration Services (SSIS) has been the go-to enterprise extract-transform-load (ETL) tool for shops running on Microsoft SQL Server. More recently,...
2020-07-28 (first published: 2020-07-16)
737 reads
Watch this week's video on YouTube
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven't been any videos in...
2020-07-16
9 reads
Watch this week's video on YouTube
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven't been any videos in...
2020-07-16
19 reads
Hey everyone. Long time no chat. I wanted to write this quick post to let you know why there haven’t been any videos in a while. If you are...
2020-07-16
21 reads
An important change to the MAXDOP documentation was made last week, with a good write up by Pedro Lopes (Twitter), a Program Manager on the SQL Server team at...
2020-07-15
223 reads
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-07-15
16 reads
In this month’s Power BI Digest Matt and I will again guide you through some of the latest and greatest Power BI updates this month.
2020-07-23 (first published: 2020-07-15)
469 reads
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
When I run my query from DW, which uses a linked server, it times...
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
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