How do you change fill factor in SQL Server? This SQL in Sixty Seconds video explains what fill factor is, its default of 100, and how to change it.
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.
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.
SQL SERVER – Parsing SSIS Catalog Messages – Notes from the Field #030
The SSIS Catalog captures a lot of cool information by default. Andy Leonard shares the query he uses for parsing SSIS Catalog messages in SSISDB.