Use shredding JSON to stage parent and child rows, validate their data, capture identity mappings, and load relational tables atomically.
SAVE TRANSACTION: Roll Back Half a Transaction
SAVE TRANSACTION sets a marker inside an open transaction. You can roll back to it and keep the earlier work. This post tests it on SQL Server 2025. It shows why a nested BEGIN TRAN can’t do the same and what XACT_STATE() returns after an error.
TRUNCATE TABLE WITH PARTITIONS: Empty One Partition Fast
TRUNCATE TABLE WITH PARTITIONS empties one partition and logs far less than DELETE. See the syntax, the index rule and the limits in SQL Server.
Handling Duplicate Key Errors 2627 and 2601 in a CATCH Block
Handle duplicate key errors 2627 and 2601 in TRY CATCH, preserve unexpected errors, and avoid racing existence checks during inserts.
Before You KILL a Session: Estimating the Rollback Cost
Before you KILL a session, inspect its transaction age, log bytes, current command, and likely rollback work, then monitor the undo safely.
Transactions and Variables – SQL in Sixty Seconds #150
Transactions and Variables both are not related at all. There is no impact of a transaction on a variable. Let us learn about it today.
DDL in a Transaction: What Rolls Back and What Blocks
DDL in a transaction works in SQL Server: CREATE, ALTER and DROP roll back like any other change. This post proves it with a small demo, lists the statements that are refused inside a transaction, and shows which locks an open DDL transaction holds and who has to wait for them.