wolfkillj (3/14/2013)

---

Actually, with SET IMPLICIT_TRANSACTIONS ON, the DELETE would implicitly open a transaction that must then be either committed or rolled back by the code.

On my SQL Server 2008R2...

wolfkillj (3/13/2013)

---

What's going on in the rest of the script? Are you certain the waits are related to this portion of the code?

As was previously stated, this is a majorly...

David Walker (4/3/2009)

---

Timothy (4/3/2009)

---

Are table aliases really that hard to decipher? Even if you had a query with 6 joined tables and every one of them using a single character...

I have to agree with Bob. I suspect that comparitively few developers really spend time learning SQL past making basic querys or the bare minimum to get the job...