Paul White (4/28/2009)

---

Ah. A post from Adam. Must be later than I realized. :w00t:

This is probably feeping creaturism, but it would be great if it could handle...

Adam Machanic (4/28/2009)

---

We're not done yet -- if we're going to create the "best" method it should do as much as possible in terms of functionality we would normally want...

Hey Paul

Completely correct. The huge advantage of the enumerator approaches should be a better scalability. Since now I only tested the single request handling to get some indicators. Workloads are...

Jeff Moden (4/27/2009)

---

Florian Reischl (4/27/2009)

---

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

Paul White (4/27/2009)

---

Hey good answers Flo.

Never be afraid of posting theoretical or odd examples of stuff without a production requirement!

And yes there is always someone that knows more about a...

Hi Lynn

Thanks for your feedback. It counts a lot for me!

Greets

Flo

Great explanation, Bruce!

I am impressed that you are already awake :laugh:

What was the requirement for MAX originally, even if it no longer applies?...

Let me clarify something...

The requirement that the functions need to return those items as NVARCHAR(MAX) is not actual any more. I have noticed that it is not possible to create...

Phil Factor (4/27/2009)

---

Can you please post the SQL build script for this CLR function, please. I'm stuck with my ...

CREATE FUNCTION ....

bit.

..and I bet most people who are trying to...

Jack Corbett (4/27/2009)

---

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

Bug in row 98... Thanks!

Either replace:

_nextPos = i + _delimiterLength;

With:

_nextPos = i; // +_delimiterLength;

Or just copy paste the complete new:

using System;

using System.Collections;

using System.Data;

using System.Data.SqlClient;

using System.Data.SqlTypes;

using Microsoft.SqlServer.Server;

public partial class UserDefinedFunctions

{

...

Hi Adam

Adam Machanic (4/27/2009)

---

Personally I like Pascal case for externally-facing variables and...

I think Core2 Quad 2,4 is not so bad 😉

All three methods use nvarchar(max). Copy paste error. Sorry again!

Changed all to...

Adam Machanic (4/27/2009)

---

OK, found it....