Lynn Pettis (4/13/2009)

---

In my blog, th flip side, I mention that the post should be concise yet detaled. Sort of an oxymoron, but it works.. The code should be...

Bruce W Cassidy (4/13/2009)

---

[font="Verdana"]No problem.

I think it's yet another example of using the right tool for the job. ...

Ok... I give up... the Tally table part of the code took 22 seconds to do the split. I stopped the function table split after 8 minutes.

I...

Lynn Pettis (4/13/2009)

---

I think I found the reason why. If you check the code, the definition field is nvarchar(max). I made some changes to the code, and only...

Bruce W Cassidy (4/13/2009)

---

Jeff Moden (4/13/2009)

---

Heh... and the stone throwing from the band wagon begins. 😉 Don't forget, I was the one that first said that Flo's beat the...

Bruce W Cassidy (4/13/2009)

---

P.S. Phil Factor's blog post makes interesting reading, particularly for this little gem:

Jeff Moden

---

P.S. Heh... Always say "Never" to a RBAR While loop... if the...

Paul White (4/13/2009)

---

Heh... no, not yet, Paul.

Jeffrey Williams (4/13/2009)

---

Here is a previous discussion that shows how to do multiple aggregations in a single pivot. We went back and forth on the various forms of pivot/cross-tab...

Heh.... then there were the new Mylar cuts and the "angel dust" the punches made. Nasty.

Anybody remember the old Remington punch cards?

GSquared (4/13/2009)

---

CLR does a faster running total than the quirky update too.

As we've known for quite some time, SQL just plain isn't good at what it isn't designed for. ...

Abhijit More (4/13/2009)

---

Vijaya,

I must appreciate for explanation you hvae provided. As you said, (*** The current batch of statements is composed of all statements entered since the last GO....***) I...

Charles Kincaid (4/13/2009)

---

Speaking of boards, one of the ones I kept hidden away was one that would dup a stack of cards and punch sequential numbers into the appropriate columns....

RBarryYoung (4/13/2009)

---

Jeff Moden (4/13/2009)

---

Heh... crud... I just sent Tony an email saying that I may have to cancel the book. Flo just beat the hell out of a...

I can almost guarantee that there will always be 50,000 distinct SomeInts on the million row test. And, although the SomeLetters2 column is pretty random, the average number per...

GSquared (4/13/2009)

---

Jeff, in your posted test harness, you need to rename the functions in the final tests. It has "SELECT SomeInt, dbo.ConcatTest...", but it needs to be Concat8kTest and...