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 "with (nolock)" in all your queries. Does anybody know how to enable the feature he was talking about, possibly even Jeff himself. I'm looking at deploying SQL Server 2008, and want to see if using a feature like this would help out my web application.
+3
A:
Jeff was talking about snapshot isolation
here is the command
ALTER DATABASE MyDatabase
SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE MyDatabase
SET READ_COMMITTED_SNAPSHOT ON
SQLMenace
2009-01-07 20:28:37
A:
What you are looking for is using READ COMMITTED with the READ_COMMITTED_SNAPSHOT database option set to ON.
Robert C. Barth
2009-01-07 20:29:29
A:
I don't think this was SQL 2008 specific, it was SQL 2005. They did have some DBA help when upgrading, though which you can read Brents's blog entry or Jeffs
John Nolan
2009-01-07 20:29:29