Recently I’ve been working with SQLCLR and the experience has been great.  There are some absolutely fantastic things about SQLCLR such as about a 60% performance increase when shredding XML and the lovely SQLBulkCopy feature.   One thing that did surprise me was when I ran the select * from sys.dm_clr_properties i to see the CLR settings, the version it indicated v2.0.50727 !  This was a surprise.  However after a little digging I found out that not only was this intentional but that it was not going to change in SQL 2008 R2.   Doug Holland has a great post explaining the reasoning.  I’m guessing that the SQL team will have to do quite a bit of work to be able to support the multiple CLR hosting that .Net 4.0 will enable.   With that said, SQLCLR is still a wonderful thing!

Happy Coding.