Understanding Key-Range Locks in SQL Server: What You Need to Know for Optimized Concurrency