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!