Viewing 2 posts - 1 through 2 (of 2 total)
You are absolutely correct here. A test I just completed using an iTVF instead of the scalar function (source table(s) ~110M records) has turned a 8:42 duration to :03....
January 4, 2016 at 2:18 pm
#1849366
Thanks for the article, Mickey.
Have you tested your scalar UDF using schemabinding? We're testing that now to see if we can bring some of the cost down,...
January 4, 2016 at 1:34 pm
#1849342