• It would be very interesting to see the differences using the profiler. In a demo I saw recently the client statistics showed a performance gain but when they ran profiler to compare the t-sql and clr, there was a lot higher cpu utilization on the server.

    I think you are really onto something with converting the data types to .net, excellent article! I learned a lot.