Introduction Fill Factor is a parameter most of us have ignored because there is no definitive way to calculate what the correct value should be. Part 1 of this series describes a new technique to dynamically determine index fill factors for all indexes within a database. Part 2 covers an analysis of the data collection […]
2019-08-27
4,007 reads
This week Steve is wondering if you know how to use waits and queues for troubleshooting.
2019-08-23
679 reads
Introduction So what’s all the fuss about Fill Factor? It is a SQL Server parameter I’ve ignored for 20+ years. The main reason was/is I’ve had no idea about what value to use. There is just no documented definitive guidance. Back in April at SQL Saturday #830 - Colorado Springs, I attended two sessions by […]
2019-08-20
9,115 reads
When you build a VM for SQL Server in Amazon EC2, Azure VMs, or Google Compute Engine, it’s all too easy to overlook the CPU speeds that you’re getting.
2019-05-03
Deadlocks have been constant troublemakers for database professionals for years. They seem to show up from nowhere and keep on happening again and again. Pinal Dave provides some oversight.
2019-04-05
SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading
2019-01-15
3,258 reads
In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading
2018-12-10
2,593 reads
In this article Anoop Kumar discusses Automatic Tuning, a new database feature that helps improve SQL Server query performance automatically.
2018-07-10
4,171 reads
This article compares SELECT INTO and INSERT INTO under different scenarios, and the best approach preferred.
2016-08-05 (first published: 2015-06-09)
21,737 reads
Learn how to approach performance tuning in this piece from SQL Server MCM and MVP, Gail Shaw.
2017-02-10 (first published: 2015-06-08)
16,815 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