.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.

Advertisements
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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s