SQLTeam.com | Weblogs | Forums

TempDB

#21

why With Tablock? What happens if you remove that? Could your query be waiting on others?

0 Likes

#22

Are your join on columns indexed? If not they should be. Even so, you need to change your expressions like:

isnull(a,'(novalue)') = isnull(b, '(novalue)')

to

(a = b or a is null and b is null)

to take advantage of indexing.

0 Likes