Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Hi,
Attached is some of the examples source code for the SQLCLR Demo on the 15th - Apologies for lateness - I've been out of the picture for a while with new Baby Girl;-)
I especially like the Modulo10 comparison between SQLCLR and a UDF. On My computer the SQLCLR completes in about 500 ms and the SQL UDF in about 2.5 seconds, and thats only on 81,000 rows!! Modulo 10 is a very simple calculation, imagine this on a very complex calculation like pension annuity rates, or some sort of newton-raphson iterative equation.
There are also a good few TVF examples. Please ping me if you have a difficulty with any of them.