Question
Locking READ COMMITTED vs. READ_COMMITTED_SNAPSHOT: how do they handle readers, and when should each be used?
Answer
Locking READ COMMITTED: shared locks, so readers and writers block each other. RCSI: readers get the last committed version as of statement start, no shared locks; versions in tempdb, or the database's persistent version store with ADR. Use RCSI to cut blocking unless code depends on blocking reads.