or with a join

UPDATE EMP

SET ID = ISNULL(DEPT.ID, 0)

FROM EMP LEFT JOIN DEPT ON EMP.NAME = DEPT.NAME

- If the application is holding locks, does that mean you suspect that it is executing more than one query apart from the one i'm analyzing and that is...

I can't find the exact definition for duration at the moment. But it could be that the application is holding locks till all rows are fetched.

The results are both executed...

nice one

identity(1,1)

Identity seed (=start) = 1 (first parameter)

Increase by 1 (second)

I see that the query executed directly on the database needs 65221 reads and takes 0.5 secs

And when it is the VB application that requests the query it needs also...

can I see a link to these best practises?

All best practises I've seen mention that all objects should be owned by dbo.

(permission chaining, limiting wildgrowth,...)

Databases are normally owned by sa...

out of my head:

varchar: easily searchable but limited to 8000 characters (4000 for nvarchar)

text: allows more but is not so searchable because it isn't stored in the "record" itself, just...

normally this means you have to reapply the service pack

Are you allowed to change the field back to autonumbering?

1) Do the tables in the new db have primary keys?

2)Is the user allowed to insert data (permissions?)

That query is huge.

I'll look into it tomorrow

I wouldn't count on sql server 2000 and sql 2005 living happily together on a cluster. A test would be at place.

You surely can install 2005 next to 2000 like...

No clue, I'm total new to SAN'S.

Does HP mayhaps have new firmware/software updates?

Is this using sql enterprise edition or higher?