Avatar of 25112

asked on 

can lot of CASTs/Union or ISNULL possibly cause blocks?

This query runs fine every day scheduled.. but yesterday, it was blocked by itself in sysprocesses.. when I did select * from master..sysprocesses where blocked<>0 I saw 12 lines all for this one process running this, and all with same spid and same blocked column data.

is it because of excessive UNION/CAST etc. CAn you suggest?
Microsoft SQL Server 2008SQL

Avatar of undefined
Last Comment

8/22/2022 - Mon