
Archive:
Search site:
Tags:
Blocking (1) Concurrency (1) Execution Plans (2) GETDATE (1) Indexes (1) internals (7) Optimization (2) Performance (5) RCSI (1) SQL Server (9) Statistics (1) Triggers (1) Version Store (1)
Categories:
Tag: Triggers
-
Here’s one I stumbled across recently – I was monitoring tempdb space and could see some version store usage on a database that did not have snapshot or Read Committed Snapshot Isolation enabled, I was puzzled by this, but eventually found the answer. What is the Version Store? As a quick primer, the version store…