Phil Factor (4/25/2009)

---

Most data feeds are a bit more regular, I'll admit, but then it is great for testing text parsing routines. I've had to parse larger strings than this...

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

If you can't use full-text for whatever reason, another approach would be to use a trigger on the PickItFrom table to save the occurrences of a PickPhrase within each new...

Jeff Moden (4/25/2009)

---

Paul White (4/25/2009)

---

One last thing. Using SELECT INTO to create the result table is a bit unfair on any method (e.g. a stored procedure) which cannot be...

Jeff Moden (4/25/2009)

---

That's exactly what my testing was showing me. Randomness of position of the delimiters from row to row makes or breaks the double barreled Tally methods and...

Flo,

As threatened^H^H^H^H promised, here is a quick example of the BCP method (in SQLCMD mode in SSMS):

Doing this in tempdb obviates the need to set recovery appropriately to enable fast...

Yeah, I know how you feel...!

By the way, reading the whole data column (all rows at once) inside the CLR TVF works very well. Splitting that data...

Which one, Phil? :unsure:

[dbo].[fnParseList]

[dbo].[ufn_SplitLines_Cursor]

[dbo].[WhileSplit]

All seem to feature a while loop - those are from Flo's DDL.sql...

Hey Flo!

These new tally solutions are only fast if all the rows in dbo.JBMTest are identical.

The QO can tell from the string statistics on the CSV column that there is...

Barry,

RBarryYoung (4/23/2009)

---

I have read this presentation and I do not see anything in it that contradicts what either Gail or I have said.

Gail

---

If you play with threads in a CLR...

Derek and everyone,

I think it's worth pointing out now that we have wandered quite a long way from the original question by Flo. This is not a complaint -...

GilaMonster (4/21/2009)

---

Do not play with threading in CLR. I believe it requires UNSAFE and, if you're not careful you could crash the entire SQL instance. If you play with threads...

James,

Several of us have already posted example code that does what you ask,...

Absolutely. ...

Hey Bob,

I *was* going to suggest rewriting it in CLR...?

:laugh:

Paul