What is optimistic vs pessimistic concurrency control in SQL Server?

Pessimistic uses locks to prevent conflicts; optimistic uses versioning to detect conflicts.

Pessimistic concurrency relies on locks to prevent other transactions from modifying data. Optimistic concurrency (Snapshot Isolation, RCSI) uses row versioning in tempdb, allowing reads without blocking writes. Conflicts are detected at commit time.