Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » High Availabili... » T-SQL   (RSS)

SQL 2005: Making sense of the new Optimistic Concurrency Controls and the readers that block writers

For a long time now Oracle enthusiasts have bashed SQL Server for not having Optimistic Concurrency Controls. They would demonstrate a SQL Server reader blocking a writer and possibly a writer blocking a reader. Thus, having appeared to demonstrate that
 
Page view tracker