A reader wants to add identity column values to an existing table in the order of another column, not the default order. Here is my answer. Do you know a better one?
ANSI_NULLS Puzzle and NULL in SQL Server: SQL in Sixty Seconds #052
This ANSI_NULLS puzzle starts with two queries that look alike, and only one returns a row. The tests here explain the NULL logic behind IN and NOT IN, show what SET ANSI_NULLS OFF still does on SQL Server 2025, and give a safer pattern for real queries.
SQL SERVER- Solution – SQL Puzzle of SET ANSI_NULL
The solution to my Puzzle of SET ANSI_NULL: why IN returns a row but NOT IN returns nothing when the list has a NULL, and how SET ANSI_NULLS ON explains it.
SQL SERVER – How to INSERT data from Stored Procedure to Table – 2 Different Methods
How do you INSERT data from stored procedure results into a table? I show 2 methods: one when the table exists and one when it is created at run time.
Blog Launch Checklist: What to Set Up Before Your First Post
A blog launch checklist saves you from mistakes that are hard to fix later. This post walks through domain and HTTPS, a phone-friendly theme, the About page, search, categories, ways to follow, analytics, tested backups and the first three posts.
Snapshot Isolation Update Conflicts: Handling Error 3960
Reproduce snapshot isolation update conflict error 3960, compare read committed snapshot, and retry the whole transaction safely.
Blog Ideas: What to Do When You Run Out of Things to Write
Every blogger hits the day when the list of blog ideas is empty. This post shows where new topics come from: your own questions, reader comments, mistakes you fixed and old posts that deserve a better answer, plus a simple way to keep an idea list.