What is calling my T-SQL scalar function (millions of times)?

In this post we look at a method using Extended Events (XE) to identify what parent objects are calling a given SQL function and how often. The background is that I was working with a team where we identified that a certain scalar function was being executed billions of time a day and – although … Continue reading What is calling my T-SQL scalar function (millions of times)?