.Net version used with SQLCLR

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.


About JohnHowell

I am a professional software developer with over 20 years of experience. I currently specialize in Microsoft technologies such as VS, TFS, C#, VB.Net, WCF, WPF, WW, etc.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s