Difference between revisions of "CLR Support - MS SQL"

From Hostek.com Wiki
Jump to: navigation, search
(Created page with "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 integr...")
 
 
(3 intermediate revisions by one other user not shown)
Line 10: Line 10:
 
==Is the CLR supported?==
 
==Is the CLR supported?==
  
−
The CLR is supported for Dedicated/VPS servers only.  We do not currently support the CLR on our shared hosting servers.
+
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?==
  
−
Since we do not support the CLR in MS SQL on our shared servers, you will need to pull the data into a local dataset in your application code to run any .net code on it.  This can be less efficient for code that works on a large rowset since it has to bring those rows over the network from the SQL server to the web server, but it will give you similar capabilities for working with the data using the .Net runtime.
+
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.
  
  
 
----
 
----
 
[[User:Davidd|Davidd]] ([[User talk:Davidd|talk]]) 11:35, 1 November 2013 (CDT)
 
[[User:Davidd|Davidd]] ([[User talk:Davidd|talk]]) 11:35, 1 November 2013 (CDT)
 +
 +
 +
[[Category:Databases-MSSQL]]

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


Davidd (talk) 11:35, 1 November 2013 (CDT)

Retrieved from "https://wiki.hostek.com/index.php?title=CLR_Support_-_MS_SQL&oldid=3039"