Category: UDFs

Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.
December 27, 2018 | SQLPerformance.com | T-SQL, SQL Server, UDFs 0
Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer).

Get the best SQL query analysis and optimization tool – free!

Plan-Explorer-logo-RGB-800px
  • Index Analysis Sandbox
  • Statistics Analysis with Histogram
  • Management Studio Add-in
  • Plan Diagram
  • Deadlocks
  • History and Comments
Free Download Learn More