When you define tables with foreign key constraints, SQL Server must check that the foreign key constraints will not be violated during DML operations. If the foreign key columns are not indexed, there are two scenarios that will cause table locks to be placed on the foreign keyed table: During any delete operation During any […]
Read MoreSQL Server Performance
Are .Net TransactionScope Objects Creating Serializable Transactions In Your Database?
On more than a few occasions I’ve noticed that systems developed in .Net were running into lock waits due to serializable transactions. After further research I realized that developers were taking advantage of a feature for managing transactions within their .Net code. This feature is known as System.Transactions.TransactionScope. This feature is quite handy when it […]
Read More