functions can be a real headache when you’re performance tuning. For one, they don’t parallelize. In fact, if you use a scalar function in a computed column, it will prevent any query that u...
https://sqlsunday.com/2014/11/09/parallel-execution-part-1/comment-page-1/#comment-2860
the two previous parts of this series, we’ve looked at how parallelism works, how you can control it, and how it affects your query (and server) performance in different
https://sqlsunday.com/2014/11/09/parallel-execution-part-1/comment-page-1/#comment-1579
on last week’s post on parallelism, here’s part two, where we take a closer look at when parallel plans are
https://sqlsunday.com/2014/11/09/parallel-execution-part-1/comment-page-1/#comment-1546