hi,'

try this one

select a.rgt from bulk_1 as a, todos2 as b

where a.rgt <> b.rgt and a.bictb=b.bictb

OPTION (MAXDOP 1)

or

EXEC sp_configure 'show advanced option', '1'

RECONFIGURE

GO

sp_configure 'max degree of parallelism', 0

RECONFIGURE

GO

thanks

Mithun