Understanding Transactions and XACT_ABORT in SQL Server: Best Practices for Transaction Management and Error Handling.

Ranking Rows in a Table Without Resetting Ranks Within Groups Using Window Functions