Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Tally OH! An Improved SQL 8K “CSV Splitter” Function RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function
mburbea
Right there with Babe
Points: 781
More actions
July 9, 2014 at 2:46 pm
#1728220
It seems that Paul is right, which explains why it appears that the memory optimized tally tables splitter beat CLR functions at first blush. (This isn't true sadly). Adding the traceflag removes the caching advantage.