News
SQL Server 2019 introduces a custom capture option that enables you to fine-tune data collection to avoid this issue. Additionally, there are a number of enhancements around execution plan collection.
When I switched the compatibility mode to 150 (using SQL Server 2019), the same query took 900 milliseconds and the execution plan showed all of the detail of the function's execution.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback