functions performance question

I'm sure everybody agrees on the idea that SQL server 2000 functions are not well taken care of as far as performance optimization. I'm not sure if it is because they don't have excution plans? or if they have it but it's not optimized or whatever reason. The fact is they are slow!

My question for experts in that field is if this issue has been addressed in SQL 2005? or we still going to avoid the functions as much as possible?

Thanks,

Robert.

Hi Robert,

Could you please be more specific? In general it should be the other way around, see http://msdn2.microsoft.com/en-us/library/ms191007.aspx

Reasons for slowdown may be numerous and require further investigation.

Thank you,

Boris.