mtrafzer (4/16/2009)

---

I have been a programmer for over 20 years. We all know that cursors are bad. We were all told that when we learned how to do...

Oh yeah... almost forgot... the "black art" running total method requires that you have the proper clustered index to work. It will not work correctly if you reference a...

Mr. Young... very nice job. Immensely entertaining article and follow up posts to boot. My hat is off to you, Sir... I know just what you're going through...

Michelle Gutzait (4/15/2009)

---

... And I was wondering... 🙂

What are your thoughts about Adam Machanic's article:

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/running-sums-redux.aspx ?

I tried to compare Adam's code to other options and came up with this...

Thomas (4/15/2009)

---

Jeff,

Look at features you need to know to write the while loop vs. the cross Join. In the case of the while loop, you need to know about the...

As always with such a hot topic, the great battle between the "intuitiveness" of cursors comes forward. The classic example on this thread seems to have been based on...

James Tran (4/14/2009)

---

Good article RBarry Young. I got rid of my cursor by

- Store the result data in table var with rownumber

- create a row index var...

SanjayAttray (4/14/2009)

---

Interesting article. Would be waiting for second installment. Cursors are bad ( period ) but in some situations we had to use them. It becomes necessary....

Manie Verster (4/14/2009)

---

Steve had an article a couple of days ago about breaking down code in a stored proc/query to make it more readable and editable. Sometimes cursors help you...

ZA_Crafty (4/15/2009)

---

You can do even one better.

using the PK in count is faster than *

ie,

Select count(id)...

Thomas (4/15/2009)

---

However, I have, in my travels, run into situations where even though a set-based solution existed, it performed worse than a cursor in that particular version of the DBMS...

Andy DBA (4/15/2009)

---

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....

Heh... isn't that an oxymoron in itself? 😛

I keep telling folks, you don't ever want...

Bruce W Cassidy (4/15/2009)

---

[font="Verdana"]Warning! Mini rant!

I'm reading an article (it's work related, okay?) and I run across this paragraph:

"The first and most obvious reason is that the DW appliance...

Lynn Pettis (4/15/2009)

---

Jeffrey Williams (4/15/2009)

---

Okay - I am just wondering if Lynn has finally hit his limit. I'm just a bit surprised - and shocked - and the response...