Tagged with sqlserver

Sqlserver Non-clustered indexes and deadlocks

ORM tools and other abstraction on RDBMS have become ubiquitous. But there is no substitute for understanding the basics of a database. This opinion of mine was only reinforced by a recent issue which I was fixing with a colleague. Bug: Error log for showed the below exception System.Data.SqlClient.SqlException: Transaction (Process ID 53) was deadlocked … Continue reading »