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.
So SQL Server is not good at SQL.
How does it compare performance wise between alternative SQL DBs?