posted on Monday, January 17, 2005 10:43 PM by SimonSabin

User Defined Function performance comparison

My blog has moved to sqlblogcasts.com/blogs/simons
The full version of this post can be found here., http://sqlblogcasts.com/blogs/simons/User Defined Function performance comparison
The new RSS feed is here

For some time now I wanted a basic example that showed the impact of using functions (UDFs), I was looking at SQLServerCentral and saw a new piece on an LPAD function

... To read the complete version of this post go here, http://sqlblogcasts.com/blogs/simons/User Defined Function performance comparison

Comments

# CLR in SQL 2005, "to CLR or not to CLR" that is the question @ Thursday, June 30, 2005 4:36 AM

Here is the link to the presentation on CRL in SQL, with guidance on when and when not to use it.
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275334&EventCategory=5&culture=en-US&CountryCode=US...

Anonymous

# Almost 200 visitors @ Monday, October 31, 2005 6:46 PM

Today has broken my record for visitors, not quite getting to 200, which I'm quite chuffed at given the...

Anonymous

# Almost 200 visitors @ Tuesday, May 23, 2006 5:17 AM

Today has broken my record for visitors, not quite getting to 200, which I'm quite chuffed at given the...

Anonymous

# CLR in SQL 2005, ''to CLR or not to CLR '' that is the question @ Tuesday, May 23, 2006 5:26 AM

Here is the link to the presentation on CRL in SQL, with guidance on when and when not to use it.
http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?EventID=1032275334&EventCategory=5&culture=en-US&CountryCode=US...

Anonymous