sql-serversqlclrexternal-script

SQL Server language extension performance


A SQL Server Language Extension function is executed in an external process. Does it mean that when such a function is called in a Select clause it creates a new process for every row in the recordset on which it is applied?


Solution

  • I think you are confusing two different features / technologies.

    Additional details can be found in my post:
    SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated in Favor of Python or R (sp_execute_external_script)?