Hi umailedit,

can you please elaborate a little more on why you think that pessimistic locking is primitive?

I think that both locking mechanisms (optimistic and pessimistic) have their deserved place in todays database technology. The benefit of SQL Server is that you can choose between optimistic an pessimistic locking. In oracle you can't. (But the overhead of SQL Server optimistic locking seems to be more drastic than in oracle.)

For more good comparison of the locking types mvrc, mvcc and pessimistic locking, I suggest the following reading:

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

Edit: Fixed Url tags.