The Design of Software (CLOSED)

A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.

The "Design of Software" discussion group has been merged with the main Joel on Software discussion group.

The archives will remain online indefinitely.

SQL Server 2005 and Oracle's MVCC

There are many advantages of Multi-Version Concurrency Control (MVCC) in large concurrent environment and Oracle is preaching this till date. I want to know if MVCC has such benefits why is it that it is still lacking in MS SQL Server 2005. Is there any other way in SQL Server 2005.
Rohit Send private email
Friday, May 18, 2007
 
 
Sql Server 2005 supports row versioning transaction isolation.
lonely consultant
Tuesday, May 22, 2007
 
 
Is it automatically handled or need some coding.
Rohit Send private email
Wednesday, May 23, 2007
 
 
To enable for the complete database:
ALTER DATABASE <db name>
SET ALLOW_SNAPSHOT_ISOLATION ON;


To enable for a specific batch:
SET TRANSACTION ISOLATION LEVEL SNAPSHOT;

Note that some DDL statements do not work in a snapshot isolated transaction + snapshot isolation puts more pressure on tempdb.
lonely consultant
Wednesday, May 23, 2007
 
 
Run this statement to default all transactions to snapshot isolation (I would not do this on a big db.)

ALTER DATABASE <db name> SET READ_COMMITTED_SNAPSHOT ON
lonely consultant
Wednesday, May 23, 2007
 
 

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics
 
Powered by FogBugz