SentryOne Team Blog (blogs.sentryone.com)

Tag : UDFs

Jonathan Kehayias : Improve Performance of UDFs with NULL ON NULL INPUT

Jonathan Kehayias : Improve Performance of UDFs with NULL ON NULL INPUT

Jonathan Kehayias shows why it can be beneficial to use the RETURNS NULL ON NULL INPUT option for scalar UDFs.

Jonathan Kehayias : Showplan Enhancements for UDFs

Jonathan Kehayias : Showplan Enhancements for UDFs

Jonathan Kehayias shares insight about new UDF information in showplan, and shows that only some tools will show it (SSMS 17+ & SentryOne Plan Explorer).