Could some one please help me understand when to use SNAPSHOT isolation level over READ COMMITTED SNAPSHOT in SQL Server? I understand that in most cases READ COMMITTED SNAPSHOT works, but not sur...

How long should it take to run ALTER DATABASE [MySite] SET READ_COMMITTED_SNAPSHOT ON I just ran it and it's taken 10 minutes. How can I check if it is applied?

In Microsoft SQL Server, I use the READ_COMMITTED_SNAPSHOT ISOLATION ALTER DATABASE MyDatabase SET ALLOW_SNAPSHOT_ISOLATION ON ALTER DATABASE MyDatabase SET READ_COMMITTED_SNAPSHOT ON In Sessi...

Recently I had to resolve lock problems such as Transaction was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. After reading s...

In Microsoft SQL Server, is there a way to detect whether a database has had its isolation level set via the T-SQL command ALTER DATABASE <database> SET READ_COMMITTED_SNAPSHOT ON;? I cannot ...

I'm using a Microsoft SQL Server 2005 database with isolation level READ_COMMITTED and READ_COMMITTED_SNAPSHOT=ON. Now I want to use: SELECT * FROM <tablename> FOR UPDATE ...so that other...

Say, I have a person table and it has only 1 row - id = 1, name = 'foo' On one connection select p1.id, p1.name, p2.name from person p1 join person p2 on p1.id = p2.id On another connectio...

I would like to set READ_COMMITTED_SNAPSHOT to ON on my SQL Azure database, but the following code, which works with other versions of SQL Server, is not supported in Azure: ALTER DATABASE [databa...

I need to programmatically enable READ COMMITTED SNAPSHOT in SQL Server. How can I do that?

Simple question? Why is READ_COMMITTED_SNAPSHOT not on by default? I'm guessing either backwards compatibility, performance, or both? [Edit] Note that I'm interested in the effect relating to th...

In one of the Stackoverflow podcasts, I remember Jeff Atwood saying that there was a configuration option in SQL Server 2008 which cuts down on locking, and was kind of an alternative to using "wit...