This is great to know...

I've used the previous post to delete all duplicates....

Thanks

Select min(%%LockRes%%) as ident,* into #test from MyHeap group by HeapName, SomeNullColumn, SomeId, phone

delete from M

from MyHeap M

left join #test T on T.ident = M.%%LockRes%%

where T.HeapName is null

Select * from MyHeap

I really like this hidden feature...