Thinking outside the box

Patron Saint of Lost Yaks
posts - 203, comments - 734, trackbacks - 4

My Links

Advertisement

News

Archives

Post Categories

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

Print | posted on Monday, June 01, 2009 10:44 AM | Filed Under [ Miscellaneous ]

Feedback

Gravatar

# re: I am proud and humble

Congratulations!
6/1/2009 8:27 PM | Alex Kuznetsov
Gravatar

# re: I am proud and humble

Thank you!
6/1/2009 9:19 PM | Peso
Gravatar

# 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
6/2/2009 1:41 AM | Rob Farley
Gravatar

# re: I am proud and humble

Great job Peter, congratulations!
6/2/2009 2:03 AM | RBarryYoung
Gravatar

# re: I am proud and humble

Hi Peter,
Congratulations...
Thanks -- Vijaya Kadiyala
www.DotNetVJ.com
6/8/2009 5:38 PM | Vijaya Kadiyala
Gravatar

# re: I am proud and humble

Well done Peter!
6/9/2009 10:26 AM | Rick Halliday
Gravatar

# 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? :-)
6/9/2009 10:28 AM | Peso
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET