Use shredding JSON to stage parent and child rows, validate their data, capture identity mappings, and load relational tables atomically.
5 Questions Answered OUTPUT Clause – SQL in Sixty Seconds #135
I have decided to create another SQL in Sixty Seconds video discussing the OUTPUT clause. In this video, we will discuss 5 questions.
SQL SERVER – 7 Questions about OUTPUT Clause Answered
These 7 Questions about OUTPUT Clause follow my INSERT and DELETE videos. I clarify destinations, triggers and performance scope below.
Remove Trigger for Delete – SQL in Sixty Seconds #133
I am involved in the Comprehensive Database Performance Health Check. Today we will discuss how we can remove triggers for the Delete statement.
Archiving Old Rows to a History Table in Small Batches
Make archiving old rows atomic with DELETE OUTPUT, preserved source identifiers, bounded batches, reconciliation, and a job time limit.
ROWCOUNT_BIG and @@ROWCOUNT: Checking What a Statement Changed
Capture ROWCOUNT_BIG immediately after a change, validate expected counts, and handle NOCOUNT, triggers, and MERGE without stale values.
sp_executesql Output Parameters: Getting Values Back From Dynamic SQL
Dynamic SQL runs in its own scope, so a value only comes back if you ask twice. Here are the two mistakes that leave you with NULL.