Transaction and locks

This may be a naive question. Since DB Transactions with higher isolation
levels internally use locks, does it make sense to use Transactions for
concurrency management , in place of using some kind of pessimistic locks ?

Thanks,
Raj.


.

Relevant Pages

  • Re: MATREADU/MATWRITE statements timing out
    ... Pessimistic locks for transactions (required for transaction ... Optimistic locks for "masterfile updates" (which 'deteriorate' to ... field by field comparisons during actual update, ...
    (comp.databases.pick)
  • Re: Sql Server Locks
    ... Tran and Commit Tran are as close together as possible and the transactions ... > The problem is with SQL Server Database Locks. ... > client A and reinserts the same with some data changes ... > provide us any good links for this kind of scenarios. ...
    (microsoft.public.sqlserver.clients)
  • Re: Transaction and locks
    ... You should read a bit more about transactions in Books OnLine. ... All transactions use locks, even in read uncommitted level you get exclusive ... all updates are automatically transactions. ... committed snapshot, snapshot) are optimistic. ...
    (microsoft.public.sqlserver.clients)
  • Re: can you tell me why this causes a deadlock?
    ... you need to ensure you obtain all the locks required for the whole ... Session 1: ... insert into joe with values ... what two locks my original two transactions got in reverse ...
    (comp.databases.ms-sqlserver)
  • Re: SqlDataReader default locking?
    ... Let's imagine we perform the 4 following transactions one after the other ... > sub-second response time where locks are held for the minimum amount ... > hold or honor any locks, and can give you dirty reads. ... >>I just wanted to know wheter any row locking takes place when we are ...
    (microsoft.public.dotnet.framework.adonet)