Posted by Erland Sommarskog on 07/20/07 21:30

Carsten (carsten.martens@gmail.com) writes:
> 'get_current_quarter' returns an integer which is a GUID in a table
> containing business quarter definitions, like start date, end date.
> 'get_current_quarter' is a scalar UDF.

Be very careful with doing data access from scalar UDFs. It can have
adverse effect on performance.

I think Gert-Jan said this in his post, but I just wanted to
emphasize it more strongly.



--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Ongoing purging of active records causes deadlocks
• Prev in forum: Re: Establishing Precedence In ORDERBY Condition Causing Problems.
• Thread view: Re: Problem with nested function call (UDFs)

[Reply to this message]