Can you explain why? I'm struggling to see a reason to prefer CHARINDEX. It...

There is an interesting alternative that avoids the join:

SELECT Grouped.Item,

Grouped.Value

FROM (

...

Haven't I answered this same question before from you?

http://www.sqlservercentral.com/Forums/Topic987990-392-1.aspx

Are you using global temporary tables? Do these seem to be causing performance problems?

Thanks for reminding me of the other thing he said that made me want to chew my...

Dave Ballantyne (9/23/2010)

---

Im lumping the multi-statement TVF in with scalar functions, my bad terminology. My 'mental' division is "Multi Statement Function" = Scalar = Bad , "Inline Function...

Dave Ballantyne (9/23/2010)

---

Good thread , lots of useful material coming from it ,but there is an issue, SET STATISTICS TIME ON carries a performance overhead when used with Scalar functions...

GilaMonster (9/23/2010)

---

Paul White NZ (9/22/2010)

---

Oh - that one! I must admit I had to walk away and do something else for half an hour before replying to his "It...

GilaMonster (9/22/2010)

---

Sometimes I wonder if people think we're posting for our health or something.

<several people>: Change the index thusly

OP: That won't help.

<couple people>: Did you try it?

OP: That helped a...

Alvin Ramard (9/22/2010)

---

Steve, regarding "What do we need in SQL Server", would it be a good time to mention making DBCC TimeWarp no longer undocumented? Time to fully document...

Steve Jones - Editor (9/22/2010)

---

well of course not, not at the rate you people...

Nothing to add - just keeping the Thread's total ticking over.

Me...

For my money, a production-quality SQLCLR solution is closest, since it produces the best/very good performance...

Certainly.

As for the "problem" characters like ampersand, less-than, greater-than, etc,...