Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » T-SQL » High Availability and Disaster Recovery   (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