Difference between revisions of "CLR Support - MS SQL"
| Line 10: | Line 10: | ||
==Is the CLR supported?== | ==Is the CLR supported?== | ||
| − | + | Yes, CLR is supported for VPS servers only. We do not currently support the CLR on our shared hosting servers. | |
==If I am using shared hosting, what options do I have?== | ==If I am using shared hosting, what options do I have?== | ||
| − | + | If a site really has a need for CLR with MS SQL, it probably does not need to be on a shared server anyway. The option would be to upgrade to a Windows VPS so that this can be utilized. | |
Latest revision as of 02:54, 11 March 2017
This page discusses support for the CLR in MSSQL.
What is the CLR
CLR stands for "Common Language Runtime". This is the runtime that executes .Net code. The CLR integration within MSSQL allows functions written in .Net code to be integrated with your SQL queries and stored procedures.
Using the built-in SQL language to form queries will generally give you better performance than using the CLR as MSSQL is highly optimized for use with SQL. However, there are some table structures, such as hierarchies and XML, that can be complicated to work with using traditional SQL as compared with .Net.
Is the CLR supported?
Yes, CLR is supported for VPS servers only. We do not currently support the CLR on our shared hosting servers.
If a site really has a need for CLR with MS SQL, it probably does not need to be on a shared server anyway. The option would be to upgrade to a Windows VPS so that this can be utilized.