Full site membership is required for this article. Already a full member? Login here. You currently have a guest membership. You can upgrade to full site membership here (free trial available). Useful Configuration User-Defined Functions   Article Abstract: (Alexander Chigrik) In this article, you can find some useful configuration user-defined functions.   Read this article...

Related Articles - For Members. All Articles By Author Tips for using SQL Server 2000 User-Defined Functions Microsoft Outlines Enhanced Product Line and Pricing for SQL Server 2005 Known SQL Server service packs problems SQL Server Upgrade Recommendations and Best Practices - Part 2 Troubleshooting SQL Server 2005 Management Studio Troubleshooting SQL Server Command Prompt Utilities Webcast Q&A Transcript: Reporting Services Launch (Part II) Meta Data User-Defined Functions Mathematical User-Defined Functions String User-Defined Functions

RE: Useful Configuration User-Defined Functions
(posted: 12/15/2005 9:07:24 AM)
I think you can get rid of most of the variable declarations for ever-so-slightly more efficiency; for example:

....
BEGIN
RETURN (SELECT TOP 1 value
FROM master.dbo.sysconfigures
WHERE comment = 'Maximum recovery interval in minutes')
END