title: SQL Azure and READ_COMMITTED_SNAPSHOT
body: <p>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:</p>
  
  <pre><code>ALTER DATABASE [database_name]
  SET READ_COMMITTED_SNAPSHOT ON
  GO
  </code></pre>
  
  <p>First question: Is it still a good idea to set READ_COMMITTED_SNAPSHOT to ON in SQL Azure (or whatever achieves the same result)? My intention is not to lock records when they are just being read, in order to improve performance.</p>
  
  <p>Second question: If it is a good idea, what's the Azure syntax for doing it?</p>