Understanding Deadlocks in SQL Server: Causes, Diagnosis, Prevention, and Mitigation Strategies for a Scalable Database System