Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


The SQLCLR Impact


The SQLCLR Impact

Author
Message
Megan Brooks
Megan Brooks
SSC Rookie
SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)SSC Rookie (28 reputation)

Group: General Forum Members
Points: 28 Visits: 146
At one time I used a CLR string aggregator (catenate with commas between) with code taken from the SQL Server developer samples, and for a while I used an open source CLR geospatial extension (can't remember what it did). I never developed SQL Server CLR code from scratch.

These uses were not terribly important, but when I tried moving a subset of the database to SQL Azure (using the limited usage that came with my MSDN Premium subscription), I couldn't do it because of those extra assemblies. All I was doing was experimenting to become more familiar with cloud services, but I ended up concluding that, at least at that time CLR and cloud did not mix.
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45047 Visits: 39898
eric.notheisen (2/21/2014)
I worked on a project for Wells Fargo a few years ago. We had a database developer who used CLR procedures for 60 percent of his stored procs. We found the performance hit to be minimal and the flexibility to be superior. In my current work I have used CLR procedures several times when I needed to recursively look at or process .data


Flexible how and superior to what?

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Evil Kraig F
Evil Kraig F
SSCertifiable
SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)SSCertifiable (5.7K reputation)

Group: General Forum Members
Points: 5697 Visits: 7660
Never personally used it. Haven't even booted up the interface. Never had to.

One of my vendors who runs our SoR seems to use it pretty heavily. Haven't seen any particular performance concerns due to the CLR on that system. That's mostly because the bottlenecks on that one are elsewhere.


- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables

Twitter: @AnyWayDBA
starunit
starunit
SSC Veteran
SSC Veteran (254 reputation)SSC Veteran (254 reputation)SSC Veteran (254 reputation)SSC Veteran (254 reputation)SSC Veteran (254 reputation)SSC Veteran (254 reputation)SSC Veteran (254 reputation)SSC Veteran (254 reputation)

Group: General Forum Members
Points: 254 Visits: 2566
We installed one - a RegEx string handler to replace unacceptable characters. I want to put another in - a splitter, but there's no pressing need, so it's not on the radar yet.

Mark
Just a cog in the wheel.
Ken Wymore
Ken Wymore
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4420 Visits: 2342
We've implemented a couple CLR functions for string concatenation, string splitting and parsing and that is it. They are rarely used. We don't see a great need to use CLR.
jay 31143
jay 31143
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 28
Yes, we do it for the SQL Mail
Eirikur Eiriksson
Eirikur Eiriksson
SSCertifiable
SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)SSCertifiable (6.7K reputation)

Group: General Forum Members
Points: 6697 Visits: 17692
My 2 cents: SQLCLR is like any other hammer, when you hold it, every thing looks like a nail! I think it is a valuable addition to the SQL Server and like any technology, when used properly it rocks. But having outperformed CLR with set based code in certain cases and also my best efforts in other being up to 3 or 4 times slower, one realizes that there are specific nails for specific hammers. The down side in my opinion is not the technology itself but the application of it. Far to often we use what we are most comfortable with, not necessarily what is the most applicable.
Eric M Russell
Eric M Russell
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4595 Visits: 9529
Jeff Moden (2/21/2014)
eric.notheisen (2/21/2014)
I worked on a project for Wells Fargo a few years ago. We had a database developer who used CLR procedures for 60 percent of his stored procs. We found the performance hit to be minimal and the flexibility to be superior. In my current work I have used CLR procedures several times when I needed to recursively look at or process .data


Flexible how and superior to what?

When it comes to databases, scalability, extensibility, and maintainability are good, but flexibility can have some negative connotations.


"The universe is complicated and for the most part beyond your control, but your life is only as complicated as you choose it to be."
David.Poole
David.Poole
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3676 Visits: 3115
SQL# contains just about everything I'd want to do that isn't already in T-SQL.

It think SQLCLR has yet to have its day. I firmly believe that it has potential for developing a statistics toolkit and that requirement has yet to come to the fore.

We did some work with SQLCLR and service broker some time ago but it didn't catch on.

Personally I think that where there is separation between the various roles of a DBA and the roles of developers you won't get SQLCLR adoption. If you had developers with a strong database skillset then blending the two worlds together would be much more likely.

LinkedIn Profile

Newbie on www.simple-talk.com
Gary Varga
Gary Varga
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8313 Visits: 6146
David.Poole (2/24/2014)
...If you had developers with a strong database skillset then blending the two worlds together would be much more likely.


I could take exception to that!!! Rolleyes

Gaz

-- Stop your grinnin' and drop your linen...they're everywhere!!!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search