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 […]

5 (2)

2019-08-27

2,667 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 […]

5 (3)

2019-08-20

4,984 reads

Blogs

DBA Myths: The system sessions are the ones with a session_id 50 or less

By

Anecdotally any session_id that’s 50 or less is going to be a system session...

SQL Undercover TV – Encrypting SQL Backups

By

In this episode, David looks at how we can encrypt our SQL Server backup...

Using volumes in SQL Server 2019 non-root containers

By

I’ve seen a few people online asking how to use docker named volumes with...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Maintenance Window for SQL Server Critical Alerts

By WebTechie

Hello, We had some sql server have issues on some production servers.  We actually...

Capturing all Error messages caused by SQL Server code

By Lonely Rogue

Hello - The ERROR_MESSAGE() is capturing only the last message in the error stack...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers