• I did a quick test on an SQL Express 2016 instance and can confirm the differences are not as drastic as they use to be.

    SQL Server 13.0.2151 (express)

    16 Gb Memory

    Windows 10 enterprise (reported as windows NT 6.3 10586)

    3.6 GHz 4 core, 8 logical

    The timing results were:

    CPUElapsed

    109102Statistics Time Baseline

    13121470Statistics Time Function

    1300Measured Time Function

    110Measure Time iTVF

    104Measured Time Baseline

    4.81%-1.92%Baseline Difference

    0.92%13.08%Function Difference

    I've the the differences between both the CPU and Elapsed measurements.