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,667 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
4,984 reads
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-24
143 reads
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-09
2,442 reads
Ever wonder about index column order; this piece should give some insight.
2019-02-28
2,222 reads
The LAG function can really improve performance over the old double JOIN.
2019-01-21 (first published: 2019-01-14)
2,083 reads
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
2018-12-17
1,667 reads
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
837 reads
Covering indexes help UPDATE performance also
2018-05-15
2,530 reads
A start at identifying and creating TSQL statements for tables that may benefit from compression.
2011-01-13
4,490 reads
Anecdotally any session_id that’s 50 or less is going to be a system session...
In this episode, David looks at how we can encrypt our SQL Server backup...
I’ve seen a few people online asking how to use docker named volumes with...
Comments posted to this topic are about the item Numeric and Decimal, which is...
Hello, We had some sql server have issues on some production servers. We actually...
Hello - The ERROR_MESSAGE() is capturing only the last message in the error stack...
Ask SSC