To change fill factor for an index, rebuild it with a new FILLFACTOR value. The tests here measure what 100, 80 and 50 do to page count, scan reads and page splits, and when a lower value is not worth the space.
Comparing Two Schemas With sys.columns and a FULL OUTER JOIN
Use read-only queries for comparing two schemas, finding missing columns, checking type details, and reviewing indexes and modules.
SQL Server: Why Retrying an INSERT Can Create Duplicate Rows
Retrying an INSERT can create duplicate rows even with an identity primary key. These tested examples use a stable request ID to return the original order, reject changed inputs, and preserve unrelated errors.
Attach a Database in SQL Server and Detach It Safely
To attach a database, use CREATE DATABASE with FOR ATTACH and point it at the data and log files. This post detaches a demo database, attaches it again, shows the error that stops a detach, and compares the old sp_attach_db procedure with the current statement.
SQL SERVER – Planned and Unplanned Availability Group Failovers – Notes from the Field #031
In Notes from the Field #031, John Sterrett explains Planned and Unplanned Availability Group failovers in AlwaysOn, a topic that confuses many DBAs.
Explain a SQL Server Index in Sixty Seconds, Then Prove It
How to explain a SQL Server index in an interview in about a minute, then prove every word with one table. On SQL Server 2025, the same query read 5,737 pages with no index, 133 with a plain index and 3 with a covering index. Three extra indexes doubled the log of 20,000 inserts.
Restoring One Table: Restore a Copy and Move the Rows Back
Learn restoring one table by restoring a separate database copy, choosing a recovery point, and safely moving reviewed rows back.







