🗄️ The Optimistic Lock That Never Actually Checked Anything A rowversion (timestamp) column is the standard way SQL Server supports optimistic concurrency: you read a row along with its rowversion, and when you save, your UPDATE’s WHERE clause includes that original rowversion value – if someone else changed the row in between, the WHERE clause […]