The article refers to "the common language runtime (CLR)", in...

RBarryYoung (1/21/2010)

---

Really? I have definitely been under the impression, that although it is possible to stream data from CLR to T-SQL, that this is not the case either when...

Matt Miller (#4) (1/21/2010)

---

I'm curious how we go about proving one way or another. It's fairly fast, but it sure seems to be acting like it's waiting for everything...

Lynn Pettis (1/22/2010)

---

I'm sorry, but just because Steve is on vacation is no reason for professionalism to go out the window. Please refrain from personal attacks. I read...

Jeff Moden (1/21/2010)

---

Although I very much agree with most of that, the "Catch 22" there is that most T-SQL users don't know what a "complex computation" actually is nor how...

Jack Corbett (9/9/2009)

---

I assume if you take the egg out right when the water hits boiling you'll be pretty close......

This one I can actually answer 😀

Put the eggs in the pan with cold, salted water

Bring to a boil

Immediately upon hitting boiling,...

Jack Corbett (8/3/2009)

---

rustroot1,

Don't know where you are in the Northeast, but Adam Machanic and his user group put on a PASS Community Connections event in the Boston area last January....

It stems from assumptions made by people who didn't know any better, repeated over and over until those assumptions became assumed truths. These assumed...

You should get the same performance either way. The SELECT list will never get processed in the EXISTS predicate; you can put anything you want there. EXISTS checks for...

Jeff Moden (6/4/2009)

---

No. I've only tried it with a derived table which seems to always follow the clustered index even if it's wrong.

I've not tried the CTE version of...

Jeff Moden (6/4/2009)

---

To wit, I agree that the ordered CTE works in the absence of a clustered index but you might want to try the ordered CTE in the presence...

Jeff Moden (6/3/2009)

---

The following code creates a million row multiple account checkbook, does the "Fire Hose" cursor running total thing 5 times and follows that with the "Pseudo Cursor" method...

Jeff Moden (6/3/2009)

---

Heh... how would you use only Read-Only with a cursor and still only be able to return a single result set? Or are you just talking about...

Jeff Moden (6/3/2009)They are currect that a cursor would be linear... but that's terribly slow compared to the "Psuedo-Cursor" or "Quirky" update method. And, heh... Before anyone goes on...