SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

When a Community Rallies!

I have been a bit lax these past few days, but I have been having a bit of a writers block not knowing what to write about.  Well, I realized this evening there is something worth writing about, and it is happening right now on SQLServerCentral.com.  An amazing thing is happening on this thread Performance issue with tally solution.

The SSC community has come together in a effort to develop a variety of methods to parse strings.  People have put together routines that use cursors, while loops, tally tables, double barreled tally tables, double barreled double carbed tally tables, CLR procedures, and (if I remember correctly, which I might not) even a XML version.  Florian Reischl started this particular thread and has been spearheading the testing of the procedures.  Many others have joined in the project that has definitely shown what can happen when a community like that on SSC gets together.

This has been one of the most interesting threads I have had the opportunity to be just a small participant in as it has grown.  Many of us are eagerly awaiting the testing of the procedures, looking to see which one is "the best".  Early testing, however, has shown that the choice of procedures is really dependant on many factors.  I'm not going to spoil anything here, so I'm not even going to say anything more on that particular subject.

We are encouraging Flo to fully document everything that is occurring and to submit an article (or two or three) when he finally completes the testing.  I really think it will be a significant article and one that many people will reference.

If you are interested to see what is happening click on the hyperlink above and start reading!


Posted by Steve Jones on 28 April 2009

That has been an amazing thread. I'm looking forward to having someone condense the knowledge into an article. Either Flo or Jeff, or another.

Posted by Lynn Pettis on 28 April 2009

I agree.  We, the participants of the thread are already encouraging Flo to write the article.  From the last few posts, don't be surprised if it is actually several articles.

Posted by Bruce W Cassidy on 3 May 2009

I haven't been able to contribute much to it other than to cheer from the sidelines.  But I agree, it's an amazing little project.  :)

Posted by Grant Fritchey on 4 May 2009

I've been nothing but a lurker on that thread, but it really does show how it's possible for a collective approach to tear down & test hypothesis and arrive at conclusions with little organization when everyone is disciplined, focused and working without too much ego. Great job guys. I'm looking forward to the articles too.

Posted by skjoldtc on 7 May 2009

I too have been watching and learning so much. Thanks to all who are participating.

Leave a Comment

Please register or log in to leave a comment.