Welcome to TechNet Blogs Sign in | Join | Help

Browse by Tags

All Tags » High Availabili... » Business Intelligence   (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

TechNet Roadshow Example code for Microsoft SQL Server 2005 Table partitioning

For those who want to give this a try, this is the code I've been using on the 2K5 H1 roadshow for my SQL 2k5 Table Partitioning demo. USE AdventureWorks GO ALTER DATABASE AdventureWorks ADD FILEGROUP FG1 ALTER DATABASE AdventureWorks ADD FILEGROUP FG2
 
Page view tracker