It is well-known that SCHEMABINDING a function can avoid an unnecessary spool in update plans:
If you are using simple T-SQL UDFs that do not touch any tables (i.e. do not access data), make sure you specify the SCHEMABINDING option during creation of the UDFs. This will make the UDFs schema-...
@JoeObbish Ah well it was written in the context of an ongoing HP conversation. The context was lots of people referencing that msdn blog post, so to that extent it is "well known" or at least "often cited". That's not the same as saying that anyone that doesn't know that is stupid or ill-informed, or new.
Your attrition rate is getting really bad when it comes to veteran users whom you've apparently made it your mission to alienate. That's a lot worse, because we have rather a lot to do with making this site what it is and in driving new users to it. You might want to take a step back and reconsider before you engage the nuclear weapons. Meta has always been a platform for people to share their opinions in a constructive way, and although you might disagree with it, that answer was neither rude nor inappropriate. Wrong answers can be downvoted, not deleted. That's always been the rule, Tim. — Cody Gray ♦9 hours ago
In compliance with tax laws, Crunchyroll will be responsible for charging state and local sales tax for purchases made by customers after August 1, 2019"
It is well-known that SCHEMABINDING a function can avoid an unnecessary spool in update plans:
If you are using simple T-SQL UDFs that do not touch any tables (i.e. do not access data), make sure you specify the SCHEMABINDING option during creation of the UDFs. This will make the UDFs schema-...
