I have pasted the XML of the Execution plans :

This one is without explicitly mentioning the option maxdop 1

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.2" Build="11.0.2100.60" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

<BatchSequence>

...

This is happening to me as well. I am using SQL Server 2012 and have resource governer configured for MAX DOP as 1 but it does not work because the...

I was working with SQL 2008 R2 and found that to use delete when there is no match, the syntax got changed.

Instead of

"WHEN SOURCE NOT...

This will also work

SELECT SUM(unallocated_extent_page_count) AS [free pages],

(SUM(unallocated_extent_page_count)*1.0/128) AS [free space in MB]

FROM sys.dm_db_file_space_usage;

If you can't get Activity monitor to come up.

I would suggest quering the sys views. something simiar to

sys.dm_exec_sessions s

LEFT JOIN sys.dm_exec_connections c ...

I am not trying to explain Jeff but i am trying to present my idea. I respect Jeff's and yours contributions to this community. I would consider myself lucky ...

If you want to do a quick one then

Create another table with same structure and insert the rows that you don't want to delete into the other table.

Now...

Hi Jeff:

I appreciate your response to my blog.

My first article is talking about performing the deletes in an efficient manner. Suppose you have a table that have millions...

Please refer this

http://tsqltips.blogspot.com/