milani_lucie
asked on
SCHEMABINDING option for UDF - SQL Server
Hi,
Can you please explain to me in simple terms why we are going to use
SCHEMABINDING option for UDF
Please provide me a simple example on this. Please provide me code. NO articles please ...
Thanks
Can you please explain to me in simple terms why we are going to use
SCHEMABINDING option for UDF
Please provide me a simple example on this. Please provide me code. NO articles please ...
Thanks
ASKER
Does it add spooler operator "SELECT" stmts also ?
Thanks
Thanks
ASKER
BTW: What is spool ?
there are mainly two types of spool we need to beware of, table spool, index spool, which you can see in query execution plan. spool slow up the performance of the TSQL. more details, you can find in below link:
http://blogs.msdn.com/b/sqlperf/archive/2007/08/30/spool-operators-in-query-plan.aspx
http://blogs.msdn.com/b/sqlperf/archive/2007/08/30/spool-operators-in-query-plan.aspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://blogs.msdn.com/b/sqlprogrammability/archive/2006/05/12/596424.aspx
I know you TOLD that no articles please, but writing detailed description with code would be like one article so it is good to reference already well prepared link. Above link is not a BIG ARTICLE. simple small article with code snippet, if you don't understand anything out of that, kindly get back to me.