October 17, 2008 at 11:05 pm
I need one Function which output is only 1 row and 5 column.
This function is call 3000 times in 1 hour.
Which is better choice of following.
Either it is Inline-Table-values Function
OR it is Multi-Statement Table-values Function
October 17, 2008 at 11:40 pm
Heh... it depends... what does the function do? And, why does it have to be a function?
--Jeff Moden
October 18, 2008 at 3:22 am
Very hard to say without knowing what you're trying to do. However, as was said before (http://qa.sqlservercentral.com/Forums/Topic586167-145-1.aspx), the multi-statement functions tend to perform rather badly, so do be careful with them
Please, please don't post multiple threads for a single problem. It just wastes people's time answering questions that have already been answered.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 20, 2008 at 4:22 am
if possible can you post the sample code as to understand what exactly you are trying to do?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply