SQL Server's Buffer Cache: How to Calculate Dirty Page Sizes
As we know, the SQL Server buffer cache is an area or region inside the server's memory where SQL Server...
2024-02-05 (first published: 2024-01-24)
549 reads
I love this logo. Our marketing people were very creative. After the van tour last year, we decided to go with a plane this year. I wrote about the...
2024-02-05
50 reads
Quite a long title for quite an annoying issue. Let me explain the set-up first: I have pipelines running in Azure Data Factory and I want to send e-mails...
2024-02-03 (first published: 2024-02-02)
36 reads
tarrion – n. an odd interval of blankness you feel after something big happens to you bt before you feel the resulting emotional reaction – stunned by a sudden...
2024-02-02
86 reads
Best Practice Tip #1: Beware of Best Practices
It may sound contractionary that the first item of a best practices list is to be wary of...
2024-02-02 (first published: 2024-01-18)
761 reads
Recently I was doing a demo and a customer asked how I had linked my commit in Azure DevOps to the work item that existed. It’s easy, and tldr;...
2024-02-02 (first published: 2024-01-19)
166 reads
The first issue of 2024 for the ISACA Journal has been published and the articles are available both in written and on-line format. I have a regular column on...
2024-02-02
45 reads
All Spark Connect Posts
Code
Goal of this post In this post we will continue looking at the gRPC API and the AnalyzePlan method which takes a plan and analyzes it....
2024-02-01
129 reads
Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...
2024-02-01
13 reads
This week I attended THAT Conference in Round Rock, just outside Austin, Texas. This was my second time attending the conference, which is a very unique. The conference runs...
2024-02-01
63 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