Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
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: 173 | Views in the last 30 days: 5
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


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


How to get SQLCLR started in SQL Server 2005 Express via Visual Basic 2005 Express?

There is no CLR template in Visual Basic 2005 Express to get SQLCLR started in SQL Server 2005 Expre...


Learn SQLCLR Programming

Longtime author here, Michael Coles, has written a new book on SQL Server 2005 Programming and has s...

friday poll    

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones