What kind of performance problem? The way of accessing the table suggested by Kingston isn't any different...

Agreed. Thanks for posting DDL and sample data.

What Dave is calling a CTE is something like...

I don't quite get the question.

Can you post an example? Basically I would like to see:

* A CREATE TABLE script

* Some sample data, scripted as INSERT into your test...

I can't say for the worldwide trends, I don't have that perception. I can only say for my shop and what I see around me.

I got from developer and accidental...

Does it return a logon error?

You could also try the other way with a linked server.

It's well known to be so.

You have to be very careful.

Is it a named instance? Try changing (local) into your actual server\instance.

Antipodes go home. :crying:

:crying::crying::crying::crying::crying::crying::crying::crying::crying:

:crying::crying::crying::crying::crying::crying::crying::crying::crying:

:crying::crying::crying::crying::crying::crying::crying::crying::crying:

:crying::crying::crying::crying::crying::crying::crying::crying::crying:

Isn't there a third half to lose of some more goals?

:crying::crying::crying::crying::crying::crying::crying::crying::crying:

:crying::crying::crying::crying::crying::crying::crying::crying::crying:

I'm sorry. I thought you were experiencing deadlocks from the thread title.

So, what's your issue?

I'm sure the trigger doesn't do magic inside its code. You could perform the same operations getting rid of the INSERTED/DELETED logical tables.

Updating the whole table with guid = guid...

Deadlocks occur when two (or more) concurrent sessions hold locks on the same object (table, row etc.).

Typical scenario is something like this:

Session 1 ...

Paul White NZ (6/24/2010)

---

Random fact for the day:

On a table clustered on an integer IDENTITY column, SQL Server Enterprise can use linear interpolation to find the row data on the...

I was curious...