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
Mike Byrd
- Interests: Water skiing, boating, tennis, Sudoku and KenKen puzzles
More On Column Order Indexes – Part 2
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
Index Column Order – Be Happy!
Ever wonder about index column order; this piece should give some insight.
2020-12-04 (first published: 2019-02-28)
6,922 reads
Indexes: When Column Selectivity Is Not Always A Requirement
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
TOP vs Max/Min: Is there a difference?
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
How Bad are Bad Page Splits – The Rest of the Story
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
A Self-Tuning Fill Factor Technique for SQL Server – Part 2
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
A Self-Tuning Fill Factor Technique for SQL Server – Part 1
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 SQL Server LAG Function
The LAG function can really improve performance over the old double JOIN.
2019-01-21 (first published: 2019-01-14)
2,545 reads
Blogs
The Diverse Data Platform–Dativerse.io
By Steve Jones
The other day I got a note from Ben Weissman the other day that...
Extended Events and Azure SQL Database
Knowledge of how your system behaves is vital to better control, maintain, and grow...
Daily Coping 19 Apr 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Buy oxycontin 80m,xanax,Oxycodone,Ritalin,Diazepam etc WhatsApp:+1(312) 379-9621
We are most reliable and efficient suppliers/distributor of all kinds of commonly used pain...
upgrade path to SQL 2019
I read the upgrade path for standard edition to SQL server 2019, the oldest...
Ask SSC