I have this piece of SQL code:
SET Field1 = c.Field1
INNER JOIN b ON a.GUID1 = b.GUID1
INNER JOIN c ON b.GUID2 = c.GUID2...
I need some help with tuning the following query. I run it on a MS SQL 2000 server and it takes more then 5 seconds. Execution plan shows...
Separate names with a comma.