Link to home
Start Free TrialLog in
Avatar of milani_lucie
milani_lucieFlag for United States of America

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
Avatar of RiteshShah
RiteshShah
Flag of India image

here is the link which will give you an idea.

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.
Avatar of milani_lucie

ASKER

Does it add spooler operator "SELECT" stmts also ?

Thanks
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
ASKER CERTIFIED SOLUTION
Avatar of cyberkiwi
cyberkiwi
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial