I am proud and humble
A few months back, Adam Machanic launched a competition about "Grouped string concatenenation" here http://sqlblog.com/blogs/adam_machanic/archive/2009/02/27/t-sql-challenge-grouped-string-concatenation.aspx
Now Adam has publish his results here http://sqlblog.com/blogs/adam_machanic/archive/2009/05/31/grouped-string-concatenation-the-winner-is.aspx and luckily my fourth suggestion was considered the overall winner!
When seeing my competitors, I am humble to see that my suggestion performed better than other suggestions made by such people as Itzik Ben-Gan, Remus Rusanu, Rob Farley and others.
Of course I am proud to win the MSDN Premium subscription, and now I have a hunch that next competition will be with Microsoft to get this baby activated ;-)
Thanks to all who participated. I have learned a few new tricks.
And I will have to really investigate the execution plans for my two other finalists, Leonid Koyfman and Rick Holliday.
//Peter
Legacy Comments
Alex Kuznetsov
2009-06-01 |
re: I am proud and humble Congratulations! |
Peso
2009-06-01 |
re: I am proud and humble Thank you! |
Rob Farley
2009-06-02 |
re: I am proud and humble Peter - you deserved it! Mine performed far slower, so I'm very surprised to have managed to rank as an equal 4th. Rob |
RBarryYoung
2009-06-02 |
re: I am proud and humble Great job Peter, congratulations! |
Vijaya Kadiyala
2009-06-08 |
re: I am proud and humble Hi Peter, Congratulations... Thanks -- Vijaya Kadiyala www.DotNetVJ.com |
Rick Halliday
2009-06-09 |
re: I am proud and humble Well done Peter! |
Peso
2009-06-09 |
re: I am proud and humble Thank you all three! It was a close call, but I think what tipped the scale in my favor is that I dropped the total reads by distinct before joining products. And maybe telling Adam his original comparison Excel sheet was flawed? :-) |