Answered Questions

  • Jan 22 2008
    05:28 PM
    7479
    12

    Transaction Isolation Level
    • Kal_CSharp

    What is a transaction isolation level and What is the advantage of it? What are different options that we set for a transaction isolation level? Transaction isolation levels are used when we go for transactions in stored procedures used in Transact SQL.

    kirangiet

    • Aug 17th, 2010

    Isolation levels in SQL Server 2008Read UncommittedRead Committed Snapshot*Read CommittedRepeatable ReadSnapshot*Serializable* The two new Isolation levels are based on Optimistic Concurrency Model.Note: Optimistic concurrency uses row versioning instead of row locking.

    myelton

    • Jul 8th, 2008

    You need to add Snapshot to this answer.  From BOL:Specifies that data read by any statement in a transaction will be the transactionally consistent version of the data that existed at the start ...