3 ms·
>"So SQL Server is not good at SQL." That's not what was implied. SQL functions are snippets of SQL you wrap in a function to use in a larger query. The issue
by ZenoArrow 10y ago
>"So SQL Server is not good at SQL."
That's not what was implied. SQL functions are snippets of SQL you wrap in a function to use in a larger query. The issue being suggested is that SQL Server will go into single-threaded execution when SQL functions are used.
However, you can use stored procedures for the same purpose as functions without incurring the same performance penalty, so the advice was a warning about a specific SQL Server feature rather than the platform as a whole.
- exclusiv 10y agoMy mistake. I realize now the author is talking about user defined SQL functions and not app layer SQL functions for composing SQL. Thanks for the clarification.