personally if I was going to do it again, I would get ocz summit 128gb drives times 5 and do a raid 5. Don't forget how important a good...

I actually use 4 Intel 160GB X25M in a Raid 10 for our production Sql Server. They simply fly. I haven't seen a wait time on a read...

I just got motivated and wrote two CLRs for this and tested on the same 2008 server from my above post with 100000 rows as per brigzy's example.

Beginning execution loop

Batch...

I copy and pasted your exact code and deleted the CLR one. (I didn't run my function version)

I also tested on our new 2008 Server instead, my previous were...

@brigzy

Before I go ahead and try again, can you first try switching the orders around? Try running the loop version first, then select, then clr. Your Raid controller...

TheSQLGuru (11/16/2009)

---

newjcb (11/16/2009)

---

I starting writing this reply saying that this isn't very efficient at all...

However, after I tested it with large strings (I used the HTML source of the article...

brigzy (11/16/2009)

---

Here are some results comparing SQL Query/SQL function/SQL C# CLR using a modified version of Thiago's script (100k records on my laptop):

SQL Query : 4 minutes (2009-11-16 17:05:20.670 ...

I starting writing this reply saying that this isn't very efficient at all...

However, after I tested it with large strings (I used the HTML source of the article as the...