Category: Indexing

Fill Factors on Indexes – What does that mean?

By SteveStedman Posted on January 24, 2023 Posted in Indexing No Comments Tagged with fill factors, fill factors on indexes, SQL Server

In SQL Server, the fill factor is a configuration option that determines how much space is left on each page of an index when it is created or reorganized. The fill factor specifies the percentage of space that will be filled on each page, with the remaining space left as free space. The fill factor is specified as a percentage …

Fill Factors on Indexes – What does that mean? Read more »

Duplicate Indexes, What a Waste

By SteveStedman Posted on September 14, 2016 Posted in Indexing No Comments Tagged with ASC, Duplicate Indexes, Increase Deadlocks, Related Links, SQL Server, Standard Edition

Today on the tuning minute on the SQL Data Partners Podcast, we discussed duplicate indexes, which lead me to think more about and and write this post. You know there are many different ways of doing things in SQL Server, and often times you can argue that one way or the other is better, and given the right situation anything …

Duplicate Indexes, What a Waste Read more »

Database Health Monitor

Download Database Health Monitor. Make your job as a DBA easier and more productive.

SQL Server Performance Tuning

Need help with SQL Server Performance Tuning, contact Steve at Stedman Solutions, LLC for help, or take a look at the performance tuning page at the SteveStedman.com blog. We can help with tuning a single query or with figuring out why your SQL Server is running slow. Free 30 minute consultation.