071e7afb   
   From: esquel@sommarskog.se   
      
   codefragment@googlemail.com (codefragment@googlemail.com) writes:   
   > - with (nolock), which seems to be the way forward for us. The queries   
   > that are blocking are summary queries, its not critical if their wrong   
   > occasionally. I am concerned about the chance of errors though, "the   
   > query may error out due to data movement if the page your query is   
   > processing moves". Can't tell what the probablity of this error   
   > occuring is. Any thoughts on this?   
      
   You would have to code retries into the client.   
      
   > - snapshots, but considering we already have tempdb issues I doubt   
   > thats the way forward, plus 2005 only of course but would still be   
   > interested   
      
   Personally, I would go for READ COMMITTED SNAPSHOT. The nice thing here,   
   is it requires no code changes, so it's very easy to test.   
      
   But of course, if you need to support SQL 2000, there is a roadblock.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)