You wrap it in code tags: [ code ] at the beginning, [ /code ] at the end...

My eyes!!!!!

Without apple sauce 😎

Jeff Moden (11/22/2009)

---

Paul White (11/22/2009)

---

5. Actually, don't do data access at all in functions!! Unless you really really really know what you are doing, and even then be...

C# Screw,

You are certainly allowed your hour of excitement! Sorry if I come across as beating your code up, it's not intentional - I've been most impressed by the...

Jeff Moden (11/22/2009)

---

Heh... Yep... that's what I got out of it, too, but I didn't say any such thing because of the handrails that a lot of folks have been...

:ermm: That works, yes, but you know it'll suck performance-wise, right? Look at the RBAR!!!

I'm trying to be...

It's a nice idea - and very creative - but it won't work...

Jeff & Michael,

:w00t: I now understand why Jeff's method broke! :w00t:

Consider these very simple statements:

SELECT REPLACE(' ', ' ', 'X') -- Example 1

SELECT REPLACE(' ' COLLATE LATIN1_GENERAL_BIN,...

Michael,

Just a quick reply for now, because I have something else to add to this thread in a moment.

Collation determines the way character data is mapped to bit patterns, the...

Michael Meierruth (11/21/2009)

---

2- on SQL Server 2005 whenever you assign Latin1_General_BIN to your column, no matter what your database collation is, it always solves the performance problem (did you hear...

My thanks to those who have voted for the Connect item about the collation performance thing. I'll post the response here as soon as I hear anything </end-plug>

Yes. http://www.docstoc.com/docs/15431250/SQL-Server-2005-Under-the-Hood_-How-We-Host-the-CLR contains the architectural details....

http://sqlblog.com/blogs/adam_machanic/archive/2009/04/28/sqlclr-string-splitting-part-2-even-faster-even-more-scalable.aspx

FYI

Right that's me for tonight - I'm off to the other end of the North Island this weekend so won't be online much, but I'll try to check by in...