Eugene Elutin (9/5/2012)

---

Yes, in my experience I have seen a lot of real-world database projects where such performance difference (on large data-sets) would easily justify the maintainability of such overhead....

Interesting repro.

I can see the same difference you do on both SQL Server 2008 and 2012, but I'm not sure the concerns are the same across problem domains. Your repro...

Great, I look forward to seeing your repro.

Eugene Elutin (9/5/2012)

---

You may not agree. But if you need to split NVARCHAR(max) and NVARCHAR(100), CLR function declared with NVARCHAR(100) as input parameter will perform faster than one declared with...

Eugene Elutin (9/5/2012)

---

Also, I would like to add my two pence into discussion of CLR performance:

1. You may declare the same CLR function (operating with strings) multiple times in...

Not a problem. Choose either character as your delimiter....

test...

Alright kids, it's time for another round of fun...

Last week I started playing with a streaming CLR solution, hoping to come up with something that would be a bit more...

Well?

Please read this, and let me know if you have any followup questions:

http://sqlblog.com/blogs/adam_machanic/archive/2011/04/05/less-data-is-more-data-a-month-of-monitoring-part-5-of-30.aspx

Well then...

How are you measuring these waits? The only "memory wait" that exists has to do with workspace memory -- same as the view I suggested. So if you saw high...

Glad someone around here gets my jokes. (Even if they...

This error occurs when a query has to wait for memory, the wait timeout expires, and after timing out the server does not have the minimum amount of memory available...

Agreed! And abbreviations are just as dangerous.

I'm...