Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Table-valued function performance

Author  Topic 

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2012-10-30 : 11:39:28
Hi all,
I have a table-valued function that is 7 to 20 min sometimes.
I'm not sure if the execution time could be enhanced to be lower than the actual.
I'm open to any suggestions!

Thanks

--------------------------
Joins are what RDBMS's do for a living

mfemenel
Professor Frink

1421 Posts

Posted - 2012-10-30 : 12:01:29
This is a difficult one to answer without context and code samples.

Mike
"oh, that monkey is going to pay"
Go to Top of Page

Mike Jackson
Starting Member

37 Posts

Posted - 2012-10-30 : 15:11:40
Probably going to have to post your function... and some sample data.

Mike
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-10-31 : 12:37:44
If posible , could you include an Execution Plan

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -