Well - this is an adaptation of the "running totals update" algorithm. It's not exactly set-based, but it certainly does go tearing through the process quite efficiently.

drop table #mytable

DECLARE...

TheSQLGuru (2/18/2008)

---

Don't mean to co-opt the thread but can you please email me a link to the regex code you found optimal for CLR? I have a client in...

Mike C (2/18/2008)

---

What if your UDF is a scalar detereministic UDF with a constant value passed in? How many times is this UDF executed:

CREATE FUNCTION dbo.AbsoluteValue (@i INT)

RETURNS INT

WITH...

Sounds about right... The Regex "single and multiple" match functions more or less matched T-SQL (with a slight edge Regex),

but the pattern replacement test beat the T-SQL...

Okay - results time....:)

First - the test scenario setup. Since the "update" method requires a new table and a clustered index to do its thing, it's necessary to throw...

Jeff Moden (2/16/2008)

---

Matt Miller (2/15/2008)

---

I suppose you're going to tell me I'm getting to be predictable now.... :hehe:

There's the obvious way, emulating a SQL-style cursor, which seems oh so very...

I'll have to give this a whirl. I was under the impression nothing inside of anything CLR got profiled, since it was all compiled...

TheSQLGuru (2/16/2008)

---

Off Topic

Hey Matt - I got your remote "Hello" at the Raleigh Code Camp today. Some guy came up to me and said "Hey, your TheSQLGuru (had that...

...It's a shame it took them all of the way until 2005 to hear the clamouring out there, so that they introduced the "include column headers into the query output...

If you want to try this- you...

I suppose you're going to tell me I'm getting to be predictable now.... :hehe:

There's the obvious way, emulating a SQL-style cursor, which seems oh so very obvious. But ...

Jeff Moden (2/15/2008)

---

Christopher Ford (2/15/2008)

---

So I says to myself, bah, table variable...you can do it without a table variable!

... for an interesting exercise, please run this...or better yet, don't run...

Todd Engen (2/15/2008)

---

There are at least three limitations that I'm aware by using the OLEDB Provider for Microsoft Directory Services.

1. It cannot read multi-valued attributes from AD, such as MemberOf.

2....

Also - knowing what they plan on doing iteratively with these little sets of rows might be helpful. there might not be a "good reason" why they need the...

Christopher Ford (2/15/2008)

---

I'm going to guess that implementing the logic of sum(detail)=Total Payment would best be implemented on the application side in a .Net class library?

I can't think of an...