Peter Larsson Blog

Patron Saint of Lost Yaks

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? :-)