2.5 Functions (17m)
Developers are taught to reuse code by following design patterns like DRY (don’t repeat yourself). That means we usually get started writing our T-SQL in functions. Unfortunately, it turns out that scalar UDFs and multi-statement table-valued UDFs perform horribly. You’ll learn that they don’t even show up in execution plans, and how to replace them with inline […]