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)
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2020-12-11 (first published: 2019-04-24)
Ever wonder about index column order; this piece should give some insight.
2020-12-04 (first published: 2019-02-28)
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)
A look at bad page splits and how they affect your database.
2020-03-03 (first published: 2019-11-25)