Optimistic concurrency , will help prevent locking issues by creating a version store of the data to be modified in the temp db. This means a reader will no longer block a writer.

http://msdn.microsoft.com/en-us/library/ms345124%28v=sql.90%29.aspx

Pretty much everything u need to know about locking and concurrency can be found here