Foreign Keys, Blocking, and Update Conflicts Paul White looks at foreign key blocking under read committed snapshot isolation, and related update conflicts under snapshot isolation. Paul White ◆ June 17, 2021 9
Minimal Logging with INSERT…SELECT into Empty Clustered Tables Paul White explains in detail the factors SQL Server considers when enabling minimal logging for inserts into an empty clustered table. Paul White ◆ May 16, 2019 0
Performance Myths : Clustered vs. Non-Clustered Indexes Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key. Aaron Bertrand ◆ March 17, 2017 16