SentryOne Team Blog (blogs.sentryone.com)

Tag : isolation

Paul White : Allocation Order Scans

Paul White (@SQL_Kiwi) explains various ways SQL Server makes runtime decisions about whether to use the b-tree structure or perform allocation order scans.

Paul White : The 2008 R2 Bug Fix That Breaks RCSI

Paul White (@SQL_Kiwi) details a regression bug in RCSI caused by a fix for a different bug. If you are running SQL Server 2008 R2, you should read this.