Bar chart of rows written for one move on a list of 1,000 items: moving the last item to the top writes 1,000 rows when renumbering, 1,000 when shifting and 1 with gaps; moving item 500 to position 100 writes 1,000, 401 and 1; moving item 10 up one place writes 1,000, 2 and 1

Reordering a List in SQL Server: Move One Row, Write One Row

Reordering a list in SQL Server means changing a sort key, and the best design writes the fewest rows. This post compares three designs for dragging an item to a new place: renumber everything, shift the rows in between, and leave gaps. Each one is measured by rows written on a list of 1,000 items. Every result comes from SQL Server 2025.

Read More
Two scripts run twice: the plain script raises error messages 2705, 1913, 2714, 1750 on run 2 and changes the Fern price from 11.00 to 12.10, leaving 6 different rows; the guarded script raises no errors, changes 0 rows and leaves 0 different rows

Schema Snapshot: Prove a Deployment Script Is Safe to Run Twice

A schema snapshot records a table’s columns, indexes, constraints and rows, so you can prove a deployment script is safe to run twice. This post runs a plain script twice and watches a price change again. It then guards each step, runs the guarded script twice, and shows that the two snapshots match. Every result comes from SQL Server 2025.

Read More