Really strange...

I copied exactly your script (just changed the names of the functions):

Adam1: 15546

Adam2: 15380

FR: 15550

System:

Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)

Mar 29 2009 10:11:52

Copyright (c) 1988-2008...

Adam Machanic (4/27/2009)

---

Did...

Hi Adam!

Thanks for the new version! I also supposed that a char array should perform better than the string. The current test results show the opposite though...

I'm out for now...

You executed both scripts against same database?...

Hi Adam

The String Enumerator (I just called it "String Enumerator" for better understanding what it does) performs very good! Especially for more rows. I just tried with some of my...

Hi

Did you run your single script against each of the databases? Just to verify that it always runs about 1 second on each of them. It could be possible that...

Happens... 🙂

Glad to hear that it works now!

Flo

Adam Machanic (4/27/2009)

---

Hi all,

I have posted a more scalable SQLCLR string split method here:

http://sqlblog.com/blogs/adam_machanic/archive/2009/04/26/faster-more-scalable-sqlclr-string-splitting.aspx

Thanks to Paul White for pointing me to this thread. Please consider testing all of these...

I...

Hey Paul

Yes, the performance of the RegEx amazed me too! The RegEx is quiet simple "\r|\r" (no backward or forward references)...

Hi Barry

Get well soon!!

Flo

Bob Hovious (4/25/2009)

---

Paul, your solution is interesting and I'm guessing will perform better. I'm going to set up and test a little with this. ...

GilaMonster (4/26/2009)

---

Bob Hovious (4/26/2009)

---

Isn't it beautiful outside this weekend? I'm about to close the lid on my laptop and go commune with nature. This is too...

Hi

What about dynamic SQL to create the PIVOT statement?

Greets

Flo

Hi Phil

I just ran exactly your script on my system. I just removed the Tally version because this is definitely the wrong decision for this requirement.

The chart is attached. Hope...