SQL Server with Mr. Denny:

SQL CLR Procedure

1

June 14, 2012  9:00 PM

When does SQLCLR launch?



Posted by: Denny Cherry
CLR, SQL CLR Procedure, SQL Server, SQL Server 2012

A change was made to the SQLCLR, as to when the SQLCLR is loaded.  In SQL Server 2008 R2 and below the SQLCLR component was loaded only when the “clr enabled” setting, which is controlled through sp_configure, is enabled.  Even with the SQLCLR is enabled on SQL Server 2008 R2 and...

June 11, 2012  9:00 PM

SQL Server 2012, SQLCLR and Max Server Memory



Posted by: Denny Cherry
CLR, SQL CLR Procedure, SQL Server, SQL Server 2012

When SQLCLR was first introduced in SQL Server 2005, one of the big complaints that I had with it was that SQLCLR could technically steal all the memory away from the SQL Server’s buffer pool by simply growing it’s memory pool which would cause the OS to request memory back from the SQL...


July 10, 2008  11:00 AM

My Experience with putting a CRL Procedure into SQL



Posted by: Denny Cherry
C#, CREATE ASSEMBLY, CREATE PROCEDURE, Encryption, Microsoft.SqlServer.Server, SQL CLR Procedure, SQL Server 2005, SQL Server stored procedures, T/SQL

A little while ago I came upon a situation where I needed to put a CRL procedure into SQL Server 2005.  Now I've been using SQL Server 2005 since the day it went RTM, and this is the first occasion that I've needed to put a CLR procedure into SQL.  Could I have done what I needed to without a CRL...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: