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 […]
2023-01-02 (first published: 2020-09-16)
5,433 reads
In the last year I’ve published articles on indexes to include Indexes: When Column Selectivity Is Not Always A Requirement – SQLServerCentral and Query Optimizer Suggests Wrong Index and Query Plan -- Why? – SQLServerCentral. This article is a continuation of just how the optimizer interacts with the index wizard. We’ve all heard and read […]
2021-07-07
3,499 reads
A good example where the Query optimizer picks the wrong query plan and suggested index.
2021-02-25
4,913 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,555 reads
Ever wonder about index column order; this piece should give some insight.
2020-12-04 (first published: 2019-02-28)
8,411 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)
7,841 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
4,448 reads
2020-03-03 (first published: 2019-11-25)
10,584 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,864 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
8,703 reads
By Kevin3NF
Does skipping a DBA save money? Wait until your system grinds to a halt,...
By Brian Kelley
I admit that until I read the article, Who are you as a Leader?,...
Suppose you want to call a certain Microsoft Fabric REST API endpoint from Azure...
I am in the process of migrating from MySQL to SQL Server. I have...
I have the following select statement --#1 Select supplier, s.refnum, desc from supplier as...
Good morning to all. I am a novice when it comes to SQL so...
What is returned from this code in SQL Server 2022?
DECLARE @value INT = NULL , @value2 VARCHAR(20) = NULL; SELECT COALESCE (@value, @value2, 100.5) AS Result; GOSee possible answers