Survey: Do you write custom SQL CLR procedures/functions/etc

Posted by James Luetkehoelter on SQL Blog See other posts from SQL Blog or by James Luetkehoelter
Published on Wed, 31 Mar 2010 12:19:00 GMT Indexed on 2010/04/03 23:03 UTC
Read the original article Hit count: 561

Filed under:

SQL CLR

|

Survey

I'm quite curious because despite the great capabilities of writing CLR-based stored procedures to off-load those nasty operations TSQL isn't that great at (like iteration, or complex math), I'm continuing to see a wealth of SQL 2008 databases with complex stored procedures and functions which would make great candidates. The in-house skill to create the CLR code exists as well, but there is flat out resistance to use it. In one scenario I was told "Oh, iteration isn't a problem because we've trained...(read more)

© SQL Blog or respective owner

Related posts about SQL CLR

SQL SERVER – Concat Strings in SQL Server using T-SQL – SQL in Sixty Seconds #035 – Video

as seen on SQL Authority - Search for 'SQL Authority'
Concatenating string is one of the most common tasks in SQL Server and every developer has to come across it. We have to concat the string when we have to see the display full name of the person by first name and last name. In this video we will see various methods to concatenate the strings. SQL… >>> More
Error with SQL Server Setup 2012 on Windows 2012

as seen on Server Fault - Search for 'Server Fault'
I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: … >>> More
Loading/Executing CLR 2.0 assemblies in CLR 4.0

as seen on Stack Overflow - Search for 'Stack Overflow'
Can the CLR 4.0 execute CLR 2.0 IL without the need for source code recompilation? >>> More
How can I detect which version of SQL (eg SQL 2008 or SQL Azure)

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to detect which version of SQL I am dealing with to perorm various tasks, I need specifically detect if I am on SQL 2008 or SQL Azure. How can I do this with detection code written in SQL? >>> More
Putting data from local SQL database to remote SQL database without remote SQL access enabled (PHP)

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a local database, and all the tables are defined. Eventually I need to publish my data remotely, which I can do easily with PHPmyadmin. Problem however is that my remote host doesn't allow remote SQL connections at all, so writing a script that does a mysqldump and run it through a client… >>> More

Related posts about Survey

New Survey 1.2.0 release - The open source web survey and form engine

as seen on Dot net Slackers - Search for 'Dot net Slackers'
New Survey 1.2.0 release published today at http://survey.codeplex.com including multilanguage features and many new additions. Survey is a free web based survey and form engine toolkit for Microsoft's .net. written in asp.net and C#. The Survey project is a restart of the open source websurvey… >>> More
New Survey 1.2.0 release - The open source web survey and form engine

as seen on Dot net Slackers - Search for 'Dot net Slackers'
New Survey 1.2.0 release published today at http://survey.codeplex.com including multilanguage features and many new additions. Survey is a free web based survey and form engine toolkit for Microsoft's .net. written in asp.net and C#. The Survey project is a restart of the open source websurvey… >>> More
Sharepoint survey: How to identify the question fields when fetching survey information from the Lis

as seen on Stack Overflow - Search for 'Stack Overflow'
I am wanting to access survey information via the Lists web service and display the questions contained in the survey. The result contains a large number of Field nodes some of which are the questions in the survey. The other fields contain other information such as author, last changed etc. How… >>> More
Two Survey Questions not populating in survey

as seen on Stack Overflow - Search for 'Stack Overflow'
Two questions (questions #2 and #3) did not populate in my survey for respondents. All questions, including these two, was mandatory. The question is visible in the preview and when tested (testing was completed eight times). The browser is internet explorer. The survey link is: https://www.surveymonkey… >>> More
HTML: Creating tool in HTML which enables to mark on an image

as seen on Programmers - Search for 'Programmers'
I am creating an online survey-monkey for conducting a research. Participants are asked to mark the preferred places for building the parking on the map (image). In other words, participants should be able to mark on the image (map) wherever they want and subsequently I could have an access to the… >>> More