We have evolved in to using this method.

Whilst we use source control for database objects, this is a background automatic process to ensure changes to objects are captured. Though we...

Jeff,

I maintain the fastest way of splitting a string is a combined process.

1. Pass the string, delim, to clr function

2. The clr function converts each item in to a fixed...

I might be shunned from the relational community, for making the mere point.

But if there is technology in place, which permits the storage/extraction of different language versions for a bit...

I'd completely forgotten about this chain.

I was going to conduct a trial of the fastest splitter.

I think it was established Clr Table Function was very quick, and the JM's inline...

Paul

but Fillrows Clr is very slow. So unless it is ten times faster than when I first looked at it.

Can we conduct a trial?

to be honest I'd be ecstatic if...

I originally stipulated

Paul White, I am certain this is not correct.

"THE" fastest way to achieve string splitting is a 2 stage approach

1. use a CLR scalar function to convert a...

Paul White, I am certain this is not correct.

"THE" fastest way to achieve string splitting is a 2 stage approach

1. use a CLR scalar function to convert a CSV or...

Ok.

And I've got a really quick one for this solution if you start dealing with large numbers of items.

Instead of comma separating as they get passed in, turn them into...

Ignore that last post.

I've just simply compared on my server.

Rows 4096 based on huge repitition of AAAA,BB,CCCCCCCCC,D

Inline function

126 ms

123 ms

130 ms

Partial CLR plus tally table

3 ms

3 ms

3 ms

I used count(*),...

Jeff, is there any chance you could try the partial CLR method as well?

I submitted the code in previous article.

use CLR to convert the items to being a fixed width...

I should probably add to my previous submitted method.

On our server a split of 131,072 is taking 160 milli seconds.

The server is fairly standard db server spec.

Sam

select getdate()

declare

The fastest way to do this is to

1 use a CLR scalar function to convert the delimitted string as a fixed width string.

2 split it using a tally table...

For this type of problem, I like using excel web queries, and .iqy files.

An excel web query works by linking a section of the spreadsheet to the contents of a...

To update a batch of many rows at once, you might consider using the .Net SqlBulkCopy class (if you are using .net) class in to a table. It takes a...

Something you might find useful, as I did, to improve the performance.

T-SQL can split fixed width columns much faster than splitting on delimitters.

For large csv strings, it is actually more...