I am sure some of you have already experienced this but not having use Functions all that much, I recently learned that T-SQL's Scalar Functions always break Parallelism. Thus while conceptually a nice idea for compartmentalizing code it is basically useless unless you do not have parallelism available to you for one of the other reasons it might not exists in your Sequel Server databases.
That being said, I was wondering if there were some rather comprehensive, deep dives into this phenomenon as well as if there are any actual quality ways to implementing streamlining and compartmentalizing of SQL code? Basically, what Scalar Functions are supposed to do but without breaking parallelism in the process.
Lastly my apologies if this is not the correct forum for this type of question. I read through all the other forum descriptions and this is the only one seemed even close. So as a side comment, I think the forum for SQL related questions ought to be more clearly denoted as such so folks do not errantly post a question in the wrong forum.