InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 09:02:05 GMT20http://www.sqlservercentral.com/Forums/Topic523611-146-1.aspxThank you for your answers.As pointed, http://www.sqlservercentral.com/Forums/Topic446308-360-1.aspx covers this issue. I'll add my new questions to it.Luiz.Wed, 25 Jun 2008 13:33:33 GMTLuiz-458831http://www.sqlservercentral.com/Forums/Topic523611-146-1.aspxHi,Compare the execution plan.You will see the which provide the best performance for your case.Regards.Wed, 25 Jun 2008 13:05:19 GMTSQL_ABDhttp://www.sqlservercentral.com/Forums/Topic523611-146-1.aspxIt depends on what you are trying to do in the function.Wed, 25 Jun 2008 13:01:46 GMTGSquaredhttp://www.sqlservercentral.com/Forums/Topic523611-146-1.aspxCheck this good discussion here:http://www.sqlservercentral.com/Forums/Topic446308-360-1.aspxWed, 25 Jun 2008 12:46:48 GMTMannySinghhttp://www.sqlservercentral.com/Forums/Topic523611-146-1.aspxHi everyone,In the following scenarios, does anybody know if there is a difference in performance?The first uses a SCALAR FUNCTION, while the second uses a TABLE FUNCTION.SELECT t1.Code, t1.Description, fn_ScalarFunction1(t1.Code) as xyzFROM Table1 t1WHERE ….SELECT t1.Code, t1.Description, f1.xyzFROM Table1 t1 OUTER APPLY fn_TableFunction1(t1.Code) as f1 WHERE ….I was wondering if we can say that one is always better than the other, or if it depends on something else.Thanks a lot,Luiz.Wed, 25 Jun 2008 12:11:16 GMTLuiz-458831