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,127 reads
Mike Byrd
- Interests: Water skiing, boating, tennis, Sudoku and KenKen puzzles
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,691 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,317 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,779 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,796 reads
2020-03-03 (first published: 2019-11-25)
5,401 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,137 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,140 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,492 reads
Scalar Functions with Query Plans: Not all is obvious!
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
847 reads
Blogs
What is a model database?
By gbargsley
Do you ever take a look at SSMS in the System Databases section? People...
Daily Coping 26 Jan 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Rowcount estimates when there are no Statistics
When you don't have statistics, what does SQL use to calculate the estimated number...
Forums
How to create a gantt chart for event rooms during a day
Hi all, This will be my first ever post in a forum like this....
[ODBC Error]
When backup job runs we are receiving the below error and database connection closes....
Error: The size necessary to buffer the XML content exceeds the buffer quota
Hi Guys, I have a report named Master and a report named Child, Child...
Ask SSC