http://blogs.msdn.com/sqlprogrammability/archive/2006/05/12/596424.aspxThis blog describes how the SCHEMABINDING option specified during creation of T-SQL UDFs may affect query plans involving these UDFs in SQL Server 2005. Armed with this knowledge, you may find that you can dramatically improvement your query performanceen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/sqlprogrammability/archive/2006/05/12/596424.aspx#628723Tue, 13 Jun 2006 01:06:59 GMT91d46819-8472-40ad-a661-2c78acb4018c:628723SQL Server Engine TipsSQL Server 2005 has new optimization logic to use the SCHEMABINDING option to derive certain properties...http://blogs.msdn.com/sqlprogrammability/archive/2006/05/12/596424.aspx#765412Fri, 22 Sep 2006 04:08:29 GMT91d46819-8472-40ad-a661-2c78acb4018c:765412rajaniHi Tomerv <br>Thanks for sharing tip. <br>i've quick question , <br>you are right ,when i run above UPDATE stmt it does add spooler operator in query plan and just wondering does it add spooler operator &quot;SELECT&quot; stmts also ? <br>bcoz i've function which does not do any data access and only some string manipulations and what i noticed is there is no spooler operator whether there is schemabinding or not ! <br>Thanks.http://blogs.msdn.com/sqlprogrammability/archive/2006/05/12/596424.aspx#4510501Wed, 22 Aug 2007 16:39:10 GMT91d46819-8472-40ad-a661-2c78acb4018c:4510501Sql Server<p>Table spool la apelul unui UDF</p> http://blogs.msdn.com/sqlprogrammability/archive/2006/05/12/596424.aspx#9361519Thu, 22 Jan 2009 05:13:39 GMT91d46819-8472-40ad-a661-2c78acb4018c:9361519using functions on sql server | keyongtech<p>PingBack from <a rel="nofollow" target="_new" href="http://www.keyongtech.com/2155852-using-functions-on-sql-server">http://www.keyongtech.com/2155852-using-functions-on-sql-server</a></p>