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
Bad habits : Focusing only on disk space when choosing keys SQL Sentry's Aaron Bertrand (@AaronBertrand) examines various impacts on SQL Server – not just disk space – when choosing a GUID as a clustering key. Aaron Bertrand ◆ January 6, 2015 7
Generate random integers without collisions Aaron Bertrand (@AaronBertrand) discusses a common requirement, generating random numbers to serve as surrogate keys, and shows how you can avoid the incremental cost of preventing collisions. Aaron Bertrand ◆ September 26, 2013 3