From: TheSQLGuru on 30 Nov 2009 15:15
There is a massive and incredibly informative thread on
SQLServerCentral.com's forums on just such a topic. Quite amazing how many
ways there are to split strings!
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net
"Roy Goldhammer" <roy(a)top.com> wrote in message
>I have procedure who runs approx 10 times in one second, getting huge sting
>with many words,
> I need to convert the list of these words to table where there are more
> then one delimiter like space, ',', ';', enter, NL and more.
> for example: "one two,three
> five" should be 5 words.
> on sql server i need to go one by one and it cause me alot. ON clr there
> is split option which do it very fast. But as i explain it saves the data
> into temp table on tempdb, which cause me to work very slow.
> and this is what i want to bypass.
> can you help me on it?
> "TheSQLGuru" <kgboles(a)earthlink.net> wrote in message
>> Not a CLR guru here but I thought when you streamed data back to sql
>> server as a clr 'table' it was directly consumed by the query plan.
>> What are you actually going to do with these 10 files converted to inline
>> tables per second queries??
>> Kevin G. Boles
>> Indicium Resources, Inc.
>> SQL Server MVP
>> kgboles a earthlink dt net
>> "Roy Goldhammer" <roy(a)top.com> wrote in message
>>> Hello there.
>>> I need to build CLR which gets text and converting it to table.
>>> this CLR should run 10 times in one second.
>>> By default(as far as i know) the retuned table of CLR is saved to temp
>>> db like any other table valued function.
>>> This can cause to system to work mutch slower then it is.
>>> Is there a way to bypass this problem?
>>> any help would be useful