Consider the following scenario. You have a partitioned table in Microsoft SQL Server 2008. You implement data definition language (DDL) statements against the partitions that are defined in the table. For example, you split, merge, or drop the partitions. At the same time, you insert data into the partitioned table, and then you query data from the partitioned table. In this scenario, a deadlock occurs.
This issue is likely to occur when you run a SQL Server 2008-based application that uses partitioned tables.