A failed SQL Server 2014 SP2 left the service down with: ALTER DATABASE statement not allowed within Multi-statement Transaction. Here is how to fix it.
SQL SERVER – Error: 8509 – Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: 0x8004d00e(XACT_E_NOTRANSACTION)
A client’s JDBC XA transactions failed with Error 8509: import of MS DTC transaction failed (XACT_E_NOTRANSACTION). Here is what we checked and how we fixed it.
SQL SERVER – How to Update Two Tables in One Statement?
One Statement normally updates one target table in SQL Server. I use a transaction when two changes must succeed together.
SQL SERVER – FIX : Error: 3456, Severity: 21 – Could not redo log record (xx:xx:xx), for transaction ID (x:xx), on page (x:xx), database ‘master’
Could not redo log record in master, error 3456, and SQL Server would not start. How we rebuilt and recovered, and the backup that makes it simple.
Triggers That Assume One Row: Fixing Them for Multi-Row Updates
Fix triggers for multi-row updates by joining inserted and deleted, testing complete audit coverage, and keeping transaction work small.
Upsert Patterns in SQL Server Without Race Conditions
Compare upsert patterns under concurrent calls, protect missing-key ranges, test MERGE with HOLDLOCK, and keep unique keys as a guard.
A Retry Loop in T-SQL for Deadlock Victims and Lock Timeouts
Build a bounded retry loop for deadlock and lock-timeout errors, roll back each failed transaction, and keep diagnostics beside retries.