Hanging Query

[Azzuron]

Hello everyone. We have a script with a periodic hanging query. What i mean, is that it sometimes seems to work, it sometimes seems to just hang up and never finish.

I have identified the query to be:

Update tp
set tp.descrip = bb.description
from [translation-new].dbo.products as tp, brokerbin.dbo.[compaq_parts] as bb
where tp.descrip IS NULL and
tp.code = bb.[Part Number] and
bb.Cond = 'NEW';

Here are the tables:

brokerbin.dbo[compaq_parts]:

[Part Number] - varchar(255)
Mfg - varchar(255)
Cond - varchar(255)
Price - varchar(255)
Qty - varchar(255)
[BBin Freq] - varchar(255)
Description - varchar(255)

[translation-new].dbo.products:

id - Int
catcount - Int
agrpcount - Int
pgrpcount - Int
disp_order - Int
code - varchar(256)
name - varchar(256)
tumbnail - varchar(256)
image - varchar(256)
price - float
cost - float
descrip - varchar(256)
weight - float
length - float
width - float
height - float
taxable - smallint
TDProdID - varchar(20)
active - smallint
cond - varchar(256)
basecode - varchar(256)
RecordSource - varchar(256)

I have been able to use the Where Clause to perform a select 100% of the time. however when this where is used in an update it stops working and the resource usage for the sqlserver is at 100% CPU. I am at a loss on this one.. thanks for any help you can provide.

--Dave

[iburyak]

It is just a guess:

Try to change this line

[PHP]tp.descrip IS NULL [/PHP]
to

[PHP]isnull(tp.descrip, '') > ''[/PHP]