Deadlocks caused by Missing Indexes in SQL Server

In today’s blog posting I want to demonstrate how missing indexes on tables can cause deadlocks in SQL Server. For the preparation of the test scenario the following code creates 2 tables and populates both tables with 4 records. — Create a table without any indexes CREATE TABLE Table1 ( Column1 INT, Column2 INT ) …

Deadlocks caused by Missing Indexes in SQL Server + read more