There are a number of knobs and switches that are available to database administrators that can be used to enable better performance. There are three options in particular that...
2020-07-31
10 reads
There are a number of knobs and switches that are available to database administrators that can be used to enable better performance. There are three options in particular that...
2020-08-12 (first published: 2020-07-31)
1,690 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-31
27 reads
This was initial posted on SQL Server Central articles. As one of dbatools' first members, I've been using it for years and it's really my goto tool. This task...
2020-07-31
189 reads
I’m excited and happy to announce that I’m part of the AWS Community Builders. Check out more on Twitter with the #AWScommunity tag. To learn more about the program...
2020-07-31
37 reads
A few years back, I wrote a blog post about using an SSIS object variable as a data flow source. In that post, I described how you could load...
2020-07-30
265 reads
I’m excited to be able to announce that the AWS Community Builders, a new program for those who help out with AWS technologies, has been launched. You can read...
2020-07-30
15 reads
Reading Steve Jones’ posts about daily coping and seeing how it has affected me in a positive way, I’ve decided to share some of the things I’ve done to...
2020-08-14 (first published: 2020-07-30)
314 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-30
16 reads
Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I...
2020-08-11 (first published: 2020-07-30)
743 reads
By Steve Jones
Thanks to everyone that attended my sessions at VS Live San Diego yesterday. It...
By Steve Jones
I was creating a question on sp_readerrorlog and realized that this procedure is different...
By SQLPals
Why sys.fn_dblog Is Undocumented And Why It's Still There Why sys.fn_dblog...
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