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,452 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,583 reads
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-24
138 reads
Continued analysis of index architecture with revised clustered index. Part 2 of Column Order Indexes
2019-04-09
2,429 reads
Ever wonder about index column order; this piece should give some insight.
2019-02-28
2,184 reads
The LAG function can really improve performance over the old double JOIN.
2019-01-21 (first published: 2019-01-14)
1,986 reads
Is there a difference between using TOP and MAX/MIN to return and end value to a table?
2018-12-17
1,653 reads
Scalar functions in Query Plans just don't always show the whole story!
2018-06-04
835 reads
Covering indexes help UPDATE performance also
2018-05-15
2,054 reads
A start at identifying and creating TSQL statements for tables that may benefit from compression.
2011-01-13
4,487 reads
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...
By damianwidera
This is the sixth interview we have done. This time our guest is Greg...
By Arun Sirpal
I want to do a quick summary post of the many different types of...
Comments posted to this topic are about the item Is Data the Future of...
Good Morning, We had an issue yesterday where SQL Alerts were generated from one...
Hi there, I am looking for a way to import kafka event data into...
Ask SSC