Mark Cowne explains his solution to TSQL Challenge 14
Mark Cowne’s solution came on top of the 10 best solutions we identified for TSQL Challenge 14. The winners of TSQL Challenge 14 are listed here. The performance test results showed that Mark’s solution had 0 writes, lowest CPU usage and was the fastest. You can see the performance comparison of the different solutions here.
Mark wrote a detailed explanation of his code that explains the approach used and a step-by-step tutorial that explains how he built such an efficient solution. I am very sure this explanation will be helpful for many TSQL developers to learn the technique used in this solution and use them in their environment.
Here is the explanation written by Mark.