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 […]

You'll need a membership to access this course. Check out my training classes.