Let me amend that: the log files should be moved to C:, if you cannot get another mirrored disk set to put them on. That would be highly...

Timmer (7/28/2008)

---

Sorry, I thought I was clear about the disks. C: is a 76GB 15k disk by itself, tempDB is there. It is mirrored. E: is the...

I think that you need to find out what the other process in the deadlock is doing also.

Where's the COMMIT?

!!!

Wow. That sounds like...

Even in Simple mode, you must have them, they are not optional.

tempDB is on C, which is a...

My thoughts exactly.

We cannot see your XML. Please attach it as a separate file.

Whats the file and disk configuration, including TempDB? Sounds like you may have your log files on the same drives as the data files. Also, raid 5 is...

Posting the table definitions with indexes would be very helpful also.

Yeah, but so does the second one.

Hmmm, you're right, revisiting and upgrading a lock in a series of already locked resources will open a deadlocking window. Technically, relocking resources that were already locked before the...

Frankly, I am surprised that either one works. It seems to switch between apostrophes and quotation marks randomly and it is not at all clear what string you are...

The follow SQL code demonstrates that this syntax does in fact work correctly:

Select count(*)

From (sys.columns A INNER JOIN sys.objects B on A.object_id = b.object_id)

LEFT OUTER JOIN

(sys.endpoints C INNER...

a648 (7/28/2008)

---

I was a bit stumped that I couldn't do the following, though :

(A INNER JOIN B) LEFT OUTER JOIN (C INNER JOIN D)

- where A & B represent our...