Is there a performance benefit to calling the web service within SQL Server, pass it the required parameters retrieved from the database, retrieve the results and update the local data,...

Thanks Matt.

Here is another interesting test from http://microsoft.apress.com/asptodayarchive/74019/sql-clr-best-practices:

Comparing Performance

Gert now presented some performance comparisons. He took two custom UDFs, one of which summed over a long series of numbers, while...

Here is what I know so far:

Developers want to deploy the CLR sproc to a single UTILITY SQL instance and allow linked server connections to the sproc from other instances....

Jeff Moden (4/2/2008)

---

Heh... you certainly did.

I'm mostly a data troll, so I don't really know... but my gut tells me that SQL Server probably shouldn't be calling a Web Service......

The interesting thing I saw was that in .NET - PI() is a constant, whereas PI() in T-SQL is a non-precise function, and POWER() seems to suck as a system...

So are you guys conceding that a CLR UDF can be much faster than a T-SQL UDF, when it comes to a complex math...

Hi Matt,

Can you post the script you ran to get these results?

I have a database restored from a full backup + txn logs.

Is there a way to find out what was the latest txn log applied (from system views)?

Actually I can...

If anything, this discussion has opened my appetite to learn more about this subject. I'm not convined, but, if in the process, I become a condemner of SQL CLR, having...

Jeff Moden (4/1/2008)

But, the real key here is that CLR's are not necessary for 99.9% of anything you do in a database. It can all be done in T-SQL...

Both are necessary.

You mention...

Matt Miller (4/1/2008)

---

Which is an interesting thought. The problem is - I'm pretty sure you have to flag that CLR as "unsafe" in order for it to be able...

It's not about DBAs allowing devs direct access to production. It has nothing to do with that.

It's about allowing...

If you set up a proxy that has cmd shell privs and write a proc that does one thing well as all procs should, AND you don't allow developers...

Jeff Moden (4/1/2008)

---

So, you're saying that a DBA must learn all possible languages that may be compiled into a CLR and have the ability to review the source code from...