MadAdmin (4/25/2016)
Thanks Hugo for giving this a review.The test you ran with the 250ms, was it on one row or the entire table?
And was it on super powerful hardware?
It was the exact code you posted. So the UDF ran on every row in order to be ab le to select the one row that qualifies.
The hardware is a VM on Windows Azure, set up through the wizard. The size I chose is "D2_V2 Standard", which gives 2 cores, 7 GB of RAM, 4 data disks of 500 max IOPS each, 100 GB local SSD, load balancing and auto scale.
(And in case you wonder, setting up the VM, running the test, the disabling the VM to stop the charges but without deleting it so I can reuse it later cost me a whopping € 0.06 out of the monthly € 130.00 allowance I have as part of my MSDN subscription).