2020-03-03 (first published: 2019-11-25)
3,952 reads
Mike Byrd
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
2,853 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
5,365 reads
More On Column Order Indexes – Part 2
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-24
193 reads
More On Column Order Indexes – Part 2
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-09
2,472 reads
Index Column Order – Be Happy!
Ever wonder about index column order; this piece should give some insight.
2019-02-28
2,356 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,242 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?
2018-12-17
1,697 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
841 reads
Covering Indexes: Not Just for SELECT but also for UPDATE statements
Covering indexes help UPDATE performance also
2018-05-15
3,441 reads
Blogs
ASF 030: Benni De Jagere interview
By Kamil
Introduction Benni De Jagere is a Senior Data Insights Consultant with a strong focus...
Figuring Out How To Hide Production Data
There’s a really simple conundrum that we go through all the time. The best...
Forums
Query Optimization Level
Comments posted to this topic are about the item Query Optimization Level
Now Is a Good Time for Choices
Comments posted to this topic are about the item Now Is a Good Time...
Design ideas for hostoric data & trending
Hi everyone, I have a use case (below) for which I am considering multiple...
Ask SSC