
Archive:
Search site:
Tags:
Compilation (1) Concurrency (3) docker (1) Execution Plans (4) internals (10) linux (3) Name Resolution (1) Optimization (4) Performance (7) Performance Tuning (2) pgadmin (1) postgres (3) RCSI (2) Schemas (1) Security (1) SQL Server (17) Statistics (1) Transactions (1) tsql2sday (1) Version Store (2)
Categories:
Tag: Transactions
-
Transaction Types
This post is just a quick reference post that outlines the three different types of transaction in Microsoft SQL Server. AutoCommit The default. Each statement in a batch works as though it had been individually wrapped in BEGIN TRAN / COMMIT so the following code block: is effectively the same as: This moves us nicely…