Don’t Use Scalar User-Defined Functions in Computed Columns.
25 Comments
Scalar functions in computed columns cause all queries that hit that table to execute serially. But it gets worse! Scalar functions in computed columns cause index maintenance to go single-threaded. If you’re running Expensive Edition, index rebuilds can be both online and parallel. That’s pretty cool, because it keeps all your gadgets and gizmos mostly…
Read More