SQL Server 2008 Concurrency Problems and Isolation(technotes.towardsjob.com)
submitted by
nitinkumarbe(175) 2 years, 8 months ago
Concurrency problems
SQL Server transaction isolation solves four major concurrency problems
Dirty read occur when a reader reads uncommitted data
Unrepeatable read occurs when existing row change within a transaction
Lost updates occur when two writers modify the same piece of state
Phantoms occur when new rows are added and appear within a transaction
Locking strategies
Optimistic concurrency
|category: Database
|Views: 3
tags:
Database another
Everyones tags:
Your Tags: