Expert SQL Server Transactions and Locking: Concurrency Internals for SQL Server Practitioners

Index

A

ABORT_AFTER_WAIT option for low-priority locks

ACID

Allocation maps

Allocation map scan, 14

Allocation unit

ALTER DATABASE SET ALLOW_SNAPSHOT_ISOLATION statement

ALTER DATABASE SET READ_COMMITTED_SNAPSHOT statement

ALTER INDEX REBUILD statement

ALTER INDEX REORGANIZE statement in columnstore indexes

ALTER TABLE REBUILD statement

ALTER TABLE SET LOCK_ESCALATION statement

AlwaysOn Availability Groups

Application lock

Archival compression in columnstore indexes

Asynchronous commit in AlwaysOn Availability Groups

Atomicity, transaction property

Autocommitted transactions

B

Batch mode execution

BEGIN TRAN statement

BeginTs timestamp

Blocked process report

blocked_process_report Extended Event, see Extended events

Blocked process threshold configuration option

Blocking ...