MVCC in SQL Server 2005

• @RDBMS

  Right there with Babe

  Points: 757

  More actions

  August 11, 2007 at 11:28 pm

  #174280

  Prior to SQL Server 2005, SQL Server had a problem of concurrency that blocked Readers with Writers and Writers with Readers. Does this version of SQL Server has any solution for this. (Multi-Version Concurrency Control).

  "Here is a test to find out whether your mission in life is complete. If you're alive, it isn't. "

  Richard Bach

• happycat59

  One Orange Chip

  Points: 29387

  More actions

  August 12, 2007 at 9:53 pm

  #726355

  SQL 2005 now has "Snapshot Isolation" which is intended to avoid this problem. Haven't have a chance to play around with it as yet though.