Query Optimizer Suggests Wrong Index and Query Plan -- Why?
A good example where the Query optimizer picks the wrong query plan and suggested index.
2021-02-25
3,207 reads
A good example where the Query optimizer picks the wrong query plan and suggested index.
2021-02-25
3,207 reads
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2020-12-11 (first published: 2019-04-24)
2,291 reads
Ever wonder about index column order; this piece should give some insight.
2020-12-04 (first published: 2019-02-28)
6,922 reads
While preparing for my SQL Saturday Salt Lake City presentation, Climbing the B-Tree, I ran into one of the “word of mouth” facts that the first column of an index should be highly selective, i.e., it should only point to one or a few rows. This is not always the case and I’ll show you […]
2020-09-16
2,352 reads
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
2020-08-14 (first published: 2018-12-17)
6,885 reads
In Part 1 of this article we looked at a specific use case (probably exaggerated) that gave us an idea about how CPU and IO performance might be affected by a bad page split. We continue this analysis looking at what really happens to the data on the leaf pages of a clustered index with […]
2020-07-02
3,844 reads
2020-03-03 (first published: 2019-11-25)
5,927 reads
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
3,184 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
6,336 reads
The LAG function can really improve performance over the old double JOIN.
2019-01-21 (first published: 2019-01-14)
2,545 reads
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Knowledge of how your system behaves is vital to better control, maintain, and grow...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
We are most reliable and efficient suppliers/distributor of all kinds of commonly used pain...
I read the upgrade path for standard edition to SQL server 2019, the oldest...