SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

The SQLCLR Impact

By Steve Jones,

While I'm sure there are a few of you still using SQL Server 2000 instances, I think at this point that most companies have moved to SQL Server 2005 and later. Even if you still manage a pre-2005 instance, chances are you have a few 2005, 2008, or 2012 instances as well.

It's been a little over 8 years since the CLR subsystem was added in SQL Server 2005. At the time this was announced, we had any number of DBAs worrying about the impact. Before SQL Server 2005 was released there were lots of concerns that developers would embed most of their database logic in SQLCLR procedures and cause lots of performance issues. That doesn't seem to have been the case, but this week I wanted to ask you about your experience.

Have you had to review and implement custom SQLCLR assemblies on your instances?

I'm looking for an idea here of the impact of the SQLCLR in your environment. Do you have standard assemblies on multiple instances or have you dealt with an ad hoc object here and there? Do you think SQLCLR is a normal part of your applications or a one-off that's rarely used? Do you go through the code and understand how the logic is implemented? Do you ensure error handling is implemented? Perhaps you've not dealt with it at all?

I haven't seen much of a call for SQLCLR objects from the various developers that have worked on the SQLServerCentral site. Most of them seem content to use their traditional tools: they use .Net code in the front end or T-SQL code in the database.

Let us know this week. Has the SQLCLR been a regular part of your SQL Server environment.

Total article views: 197 | Views in the last 30 days: 3
Related Articles

Stairway to SQLCLR Level 1: What is SQLCLR?

The first step to using the SQLCLR begins with this overview of what is possible and what is not. St...


Multi thread on SQLCLR

It's possible to implement multithreading on SQLCLR Procedure


SQLCLR vs. SQL Server 2017, Part 5: “Trusted Assemblies” – Valid Use Cases?

In the previous post in this series on SQLCLR in SQL Server 2017 — Part 4: “Trusted Assemblies” — Th...


Stairway to SQLCLR Level 2: Sample Stored Procedure and Function

In the second level of our Stairway to SQLCLR, we look at how to enable the SQLCLR in SQL Server. We...


Practical usage of SQLCLR: Building QueryToHtml function

This article shows a few techniques with SQLCLR to to transform a query result into HTML.

friday poll