Extended stored procedure, performance?  
Author Message
labaffl





PostPosted: Tue Jun 13 12:25:16 CDT 2006 Top

SQL Server >> Extended stored procedure, performance?

Hi everybody,
I should begin to write a DLL library for Sql2000 server.
The functions I like to implement are mathematical functions, like standard
deviation, and similar, nothing really complex. Often I have to use more
then one standard deviation inside the sama function, using subset of a
record set.
Of course I can use sql2000, that implemets standard deviation and basic
mathematical function, so the question is: is it opportune to write a DDL to
improve performance, or is it worse, or just the same?

thanks a lot for any kindly advice

cesare

SQL Server21  
 
 
David





PostPosted: Tue Jun 13 12:25:16 CDT 2006 Top

SQL Server >> Extended stored procedure, performance?


> Hi everybody,
> I should begin to write a DLL library for Sql2000 server.
> The functions I like to implement are mathematical functions, like
> standard
> deviation, and similar, nothing really complex. Often I have to use more
> then one standard deviation inside the sama function, using subset of a
> record set.
> Of course I can use sql2000, that implemets standard deviation and basic
> mathematical function, so the question is: is it opportune to write a DDL
> to
> improve performance, or is it worse, or just the same?
>

Extended stored procedures are so dangerous to the stability of the database
server that they should be used very, very carefully.

In SQL 2005 CLR integration provides a safe way to extent the SQL engine
with custom calculations.

David