55 minutes to run? Good grief!

Well, without seeing the structure of the underlying view (which is likely the cause of quite a few of your performance woes) there are some...

Oh, okay, that makes a lot of sense then. Thank you! It's more the 'across multiple tables or outside of tables' thing I'm having trouble finding use cases for.

Luis Cazares (10/16/2013)

---

Drew Copenhaver (10/16/2013)

---

OCTom (10/16/2013)

---

Since I'm not using 2012, yet, I didn't know about SEQUENCE. So, I looked it up and found a nice Technet article by Denny Cherry.

He...

OCTom (10/16/2013)

---

Since I'm not using 2012, yet, I didn't know about SEQUENCE. So, I looked it up and found a nice Technet article by Denny Cherry.

He not only explains what...

mtassin (9/25/2013)

---

This I find amazing... do you not use the...

This was a much trickier question than I gave it credit for. Thanks! You taught me a few things. First, I really shouldn't assume the question says "what will this...

Joshua Feierman (9/24/2013)

---

Drew Copenhaver (9/24/2013)

---

I don't often comment, but I absolutely loved this. I wish I'd had it a year ago. I mostly just spend my time lurking in the...

Maybe something about how the...

I don't often comment, but I absolutely loved this. I wish I'd had it a year ago. I mostly just spend my time lurking in the shadows of this strange...

L' Eomot Inversé (9/16/2013)

---

Drew Copenhaver (9/16/2013)

---

Steve Jones - SSC Editor (9/16/2013)

---

Drew Copenhaver (9/16/2013)

---

Yeah, my initial thought was "2, if my instance of 2008R2 properly handles regex, we'll see..." So I...

Steve Jones - SSC Editor (9/16/2013)

---

Drew Copenhaver (9/16/2013)

---

Yeah, my initial thought was "2, if my instance of 2008R2 properly handles regex, we'll see..." So I ran the code and got...

Yeah, my initial thought was "2, if my instance of 2008R2 properly handles regex, we'll see..." So I ran the code and got the error:

Msg 102, Level 15, State...