GilaMonster (8/10/2009)

---

The equivalent query using exists is this:

SELECT * FROM employee WHERE NOT EXISTS (SELECT 1 FROM emp_detail where employee.emp_no = emp_detail.emp_no)

That will probably run much the same speed as...

Very funny, Ken! Be sure to get an early start on the blame-storming!;-)

John Gregory (6/22/2009)

---

...

It sounded like you suggested deliberately causing a problem to get buy-in from your users (...sending out hundreds of thousands of emails). Perhaps I misunderstood this bit. Abusing...

Jeff Moden (4/29/2009)

---

First, "Set Based" does not equal "Doing it all in a single query". But let's forget that for a minute. Are you telling us that you...

tpepin (4/28/2009)

---

In the end, I decided that the cursor approach was probably both more efficient and more readable/maintainable. I could just be showing my inexperience here and I'm definitely...

greatheep (4/27/2009)

---

So, the gauntlet is down - any suggestions on how to achieve the same benefits using set processing?

In summary, we want:

- If there is an error in a row,...

Thanks for the post! I bet that blows the function based approach out of the water!

Goldie Graber (4/27/2009)

---

Thomas (4/27/2009)

---

Note that the comma-delimited list is sorted alphabetically. I'm aware that there is a hack using Replace, Stuff and For Xml to achieve this but it...

While the sending e-mail task presents an interesting challenge for those seeking to eliminate loops, my guess is that a tiny percentage of resources are being wasted on looping code...

bruce.trimpop (4/17/2009)

---

Both arguments are relative to the developer's experience. One is not easier nor harder than the other. If you know cursors and procedural development then cursors are easier than...

Bruce W Cassidy (4/15/2009)

---

[font="Verdana"]I'm not sure it would make much of a difference. You are still calling the email stored procedure sequentially, whether it is inside a loop or...

I apologize if this is somewhat off topic and there's probably tons of articles on it already, but here is a word to the wise on performance testing. I...

RBarryYoung (4/14/2009)

---

Andy DBA (4/14/2009)

---

Also wondering if ownership chaining is still an issue with dynamic sql. Pretty sure I can write an sp that wraps sp_dont_touch_this(@someargument varchar(25)) in a cursor...

RBarryYoung (4/14/2009)

---

I am making the claim that as of SQL Server 2005 and greater we do not need explicit Cusrors or WHILE loops because there are performant alternatives to accomplish...

I too am looking forward to follow-up articles. I'm hoping new techiques are presented in addition to a consolidation of techiques we've already seen in previous SSC articles.

I've been...