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?
Can you update two tables in One Statement in SQL Server? No. Here is why, and what people usually need when they ask for it.
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’
SQL Server would not start: Error 3456, could not redo log record for a transaction in database ‘master’. How we got the instance back up.
SQL SERVER – How to Identify a DB is Using Cross-Database Transactions?
Recently, when I was at a conference, one of the attendees came to me to ask a question. The conversation was as below for cross-database transactions.
SQL SERVER – Knowing Nested Transactions Behavior with SQL Server
Does SQL Server start a new transaction for every BEGIN TRAN inside another? I show nested transactions behavior with a simple demo for a reader.
SQL SERVER – Identify Oldest Active Transaction with DBCC OPENTRAN
How do you know if there is an open transaction before you restart a server? DBCC OPENTRAN shows the oldest active transaction in your database.
SQL SERVER – TRANSACTION, DML and Schema Locks
Most candidates in a senior developer interview could not create a scenario that shows schema locks. Here is a simple demo with a TRANSACTION and DML.