Crossing Borders
I’m about to cross a country border for the first time in almost two years. I last left the United States in December 2019. Today I’m flying to Belgium...
2021-10-07
51 reads
Daily Coping 7 Oct 2021
I 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...
2021-10-07
56 reads
Dealing with foreign keys when deleting rows.
Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of ... Continue reading
2021-10-07
110 reads
Restore to SQL Managed Instance
Now that we have a Managed Instance built, the next question is how do we get data across? I will break this up into separate posts but the lesson...
2021-10-07
147 reads
Measuring SQL Server File Latency
This post is a reference post for retrieving IO statistics for data and log files in SQL Server. We’ll look at where we can find IO statistics in SQL...
2021-11-29 (first published: 2021-10-06)
590 reads
Using NULLIF–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across the NULLIF() function recently, and...
2021-10-06
37 reads
Join me at SQL Trail 2021 to hear the next thing about Temporal Tables
I’ve had the privilege of presenting all over the world about temporal tables in SQL Server including the United Kingdom, Canada, and the United States. The theme of the...
2021-10-06
42 reads
Daily Coping 6 Oct 2021
I 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...
2021-10-06
21 reads
Azure Purview is generally available
After a very long public preview (9 months), Azure Purview is finally generally available (GA). I described Purview in a previous blog (New Microsoft data governance product: Azure Purview)....
2021-10-05
30 reads
Azure Purview is generally available
After a very long public preview (9 months), Azure Purview is finally generally available (GA). I described Purview in a previous blog (New Microsoft data governance product: Azure Purview)....
2021-10-20 (first published: 2021-10-05)
416 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