Question : When I run this query, I see high wait time for CLR_AUTO_EVENT: SELECT * FROM sys.dm_os_wait_stats WHERE wait_type […]
Tag: sql-clr
Understanding MS SQL Server Date Types
Question : Consider the following: declare @dt datetime, @dt2 datetime2, @d date set @dt = ‘2013-01-01’ set @dt2 = ‘2013-01-01’ […]
Is there a SQL Server 2008 R2 specific target for SSDT projects?
Question : I am making a SQLCLR stored procedure in Visual Studio 2012. I have these options for target platform: […]
Can CLR execution continue after ‘THROW’ is encountered in T-SQL?
Question : I am calling a T-SQL stored procedure from a CLR stored procedure. and the THROW statement in T-SQL […]
Creating SQL Assembly error Method parent has circular class type parameter constraints
Question : I’m trying to add an assembly to SQL server 2012 but I’m getting the following errors. I’ve tested […]
SQL CLR very slow on Amazon EC2 Instance (SQL Server 2014 CU6)
Question : I am running a SQL Server 2014 Standard Edition (Cumulative Updates 6) instance on an r3.large Amazon EC2 […]
Why would I get PREEMPTIVE_OS_AUTHORIZATIONOPS using tSQLt when Working at Home?
Question : I have an SSDT project containing tSQLt unit tests. I always find when working at home that publishing […]
SQL Server CLR method failing due to TLS 1.0 shutdown
Question : I have an old CLR assembly that was using .Net 2 and when our TLS 1.0 connections were […]
Why does dm_os_memory_clerks have MEMORYCLERK_SQLCLR values on one NUMA node?
Question : We are using a SQLCLR stored procedure for service broker activation, and I want to monitor the memory […]
How to capture PRINT statements from TSQL called by CLR stored procedure
Question : I have a CLR stored procedure that (among other things) calls a TSQL stored procedure. The TSQL stored […]