http://www.sqlservercentral.com/Forums/FindPost696606.aspx

My Set-based 'quirky update' solution is half way down the page on page 6 of this thread. http://www.sqlservercentral.com/Forums/Topic695508-338-6.aspx

Which is the current front-runner for the CLR solution? I'm using DanielJ's

The reason...

As far as I can tell, the difference in the results that we are getting is due to the way different servers behave with different resources and configurations. I do...

Am I right in seeing that your copy of Moby Dick only has one line? My copy is twice the length too.

I modified the WHILE loop function to make it quicker, and to give the same table of results as the Quirky Update function, which I haven't changed. The WHILE loop...

I'm sorry, folks, but these CLR string-splitting techniques don't scale up. It would be very dangerous to recommend CLR routines based on these tests because the test data was very...

The URL I gave you [p]Net Reflector: Soup to Nuts[/url] has a section that tells you how to install it. [/p]

[p]I'll pass on, to the developers, your request to have...

[p]useful links[/p]

Net Reflector download page[/url]

Net Reflector soup-to-nuts[/url]

Net Reflector add-ins[/url]

SQL 2005/8 Browser add-in for NET Reflector

[p].... and NET Reflector is the dream tool for SMO programming as...

Paul, Jeff,

I hate to disagree, but distributing a CLR this way is safe as long as you can read any current .NET language to check what is going on. All...

Derek, not me, Florian. All I'm doing is showing you guys how to test the idea! Let's get some detail on the relative performance of all these functions.

I decided I'd...

Of course, splitting a string is a variant of RegEx, which seems to be the main reason for using a CLR solution for something which could, in theory, be done...

[font="Courier New"]--================================================

-- Multi-statement Table-valued Function that splits an NVARCHAR(MAX)

-- into rows depending on a delimiter

--================================================

IF OBJECT_ID (N'splitStringToTable') IS NOT NULL

   DROP FUNCTION splitStringToTable

GO

CREATE FUNCTION splitStringToTable(@String NVARCHAR(MAX), @Delimiter VARCHAR(255))

RETURNS @strings TABLE...

We really haven't got to the bottom of what was causing the original problem.

As I'm a bit stupid, and read it too quickly, I hadn't realized that the original...

This reminds me a bit of the blog I did called 'Never say never to the 'While' loop.

A Charindex and WHILE loop will always outperform a 'helper table'...

IceDread, Yes, you're doing things pretty safely there. If you are calling a series of Stored procedures within a transaction, which you can then roll back if necessary, then the...