Re:Things Developers Should Know About SQL Server (2013)
by ZenoArrow on Sunday February 12, 2017 @05:08AM
(#13627694)
>"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.
Re:Things Developers Should Know About SQL Server (2013)
by exclusiv on Sunday February 12, 2017 @01:35PM
(#13629747)
My 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.
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.