Deadlocks

• Jonathan Kehayias

  One Orange Chip

  Points: 26778

  More actions

  July 15, 2008 at 12:18 pm

  #843323

  Steve,

  I am not sure why that won't work for you, but here is another link:

  http://msdn.microsoft.com/en-us/library/ms345124.aspx

  If that doesn't work, you can google "SQL Server 2005 Row Versioning-Based Transaction Isolation" and it will be the first document.

  EDIT: I apparently and not smart enough to put the URL tags in correctly. I have fixed my posts. Sorry for the confusion.

  Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
  My Blog | Twitter | MVP Profile
  Training | Consulting | Become a SQLskills Insider
  Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]

• steve smith-401573

  SSChampion

  Points: 10889

  More actions

  July 15, 2008 at 1:10 pm

  #843368

  GilaMonster (7/15/2008)

  Try doing a save-as

  http://download.microsoft.com/download/f/1/c/f1cf7b8d-7fb9-4b71-a658-e748e67f9eba/RowVersioningBasedIsolation.doc

  I've greatly enjoyed this thread, and a belated congratulations, Gail, on being named an MVP!

  Thanks. It's turning out to be a very good year.

  The problem was the link displayed defective in my browser; cutting and pasting into the address bar didn't work. Having a clean link solved it! Thanks to both of you for being so responsive!

• Christian Buettner-167247

  SSChampion

  Points: 13729

  More actions

  July 15, 2008 at 2:58 pm

  #843421

  I found this information really helpful:

  A not-so-very technical discussion of Multi Version Concurrency Control

  http://www.ibphoenix.com/main.nfs?page=ibp_mvcc_roman

  Best Regards,

  Chris Büttner