EDIT: I was going to respond again but then I realized I was answering the exact same argument for the third time. You ignore half of what I say...

Koen Verbeeck (2/13/2011)

---

You are certainly right. I'm afraid I didn't make myself clear with my statement.

The developer shouldn't be the only one who is testing his code. Unfortunately I've seen...

nadabadan (2/13/2011)

---

Note, our first exchange. No tangents, yet, simply a back and forth regarding the value of the question in our eyes. Now, you've begun to take offence simply because...

Tom.Thomson (2/12/2011)

---

Craig Farrell (2/12/2011)

---

Oh, I realize your argument, Jeff, and it is what I originally did. However, your statement can go both ways. Do you simply ignore a...

Publically, then. As you wish.

At my request, actually, since the last time I...

Nadabadan, since it's me you're aggravated with, perhaps we should discuss it further. PM me if you'd like to do it privately, or simply respond here publically. I'm...

GilaMonster (2/12/2011)

---

george sibbald (2/12/2011)

---

And why do people post a reply thats almost a verbatim copy of a previous post? Being proved wrong I can just about take (with embarrasement) but...

Jeff Moden (2/12/2011)

---

Tom.Thomson (2/12/2011)

---

My view is that if...

I see, so it's my sarcasm reversed to him that's got him set off. I'm sure he's quite annoyed at this. He's almost ready... just shy of a...

I Kin Hav SQL Sater-dayz?! Um, yes, most likely. Didn't even realize there was going to be...

jcrawf02 (2/11/2011)

---

The Dixie Flatline (2/11/2011)

---

QA is where some developers send their code to see if it works correctly or not. Often they do this without verifying that it...

Original, non-modified version of #TMP may have still been in memory. Usually when I...

I copied and pasted your script directly into my SSMS 2005... and don't get a failure. No idea why this is breaking.

With both of those flags enabled, you should be able to find the output of the deadlock in the error log.

srferson-957148 (2/11/2011)

---

Thanks for replying again Craig.

I do know what persisted and non-persisted mean.

I don't understand what the advantage to one over the other is.

Why do you say I'd...