SQLServerCentral.com / Editorials / SQLServerCentral.com / Closing Out Replies / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 02 Aug 2015 14:35:46 GMT20RE: Closing Out Replieshttp://www.sqlservercentral.com/Forums/Topic1183531-263-1.aspx[quote][b]GSquared (9/30/2011)[/b][hr]Which brings up, what happens if some credible expert votes for something, and five minutes later is told a better solution by someone who's completely new to the site, tests it, and finds out their solution is better? I've seen that happen numerous times.The Stack Overflow solution has positive factors, but it also has negative ones, and some of them are eggregiously negative. There are a lot of high-vote solutions on there that are valid but far from optimum. Some because they were optimum at the time they were voted for, but no longer are, others for other reasons.[/quote]Well stated Sir.Tue, 04 Oct 2011 12:13:22 GMTsturnerRE: Closing Out Replieshttp://www.sqlservercentral.com/Forums/Topic1183531-263-1.aspx[quote][b]Matthew Joughin (9/29/2011)[/b][hr]I would say the way pioneered by www.StackOverflow.com is the best way, where responses are voted for, but you can only vote for a response if you have "credibility".So then the person who finds the question later has a good indication of which the correct responses. I have found this works very well, and in fact have yet to find a question posted on Stackoverflow, which has voted answers, that didn't work as per the most voted answer!They have a api called StackExchange which allows anyone to set up the same type of site, perhaps that should be looked into...[/quote]Gail and Gus have some good points. StackOverflow works great in some ways, not so great in others. The answers and suggestions are disjointed, and there is a lot of information in the comments because the format doesn't lend itself well to many questions. Works great for some, not for others.It also doesn't necessarily help someone learn, or tease out why it's a good answer. The reordering of items also makes it hard to come into the thread later and figure out what happened, especially as items get edited and comments/answers no long apply.We are considering implementing some ideas that are similar to SO, but not it exactly. The StackExchange API isn't open, nor could we use it here. Right now there are two large projects (blog changes, Simple Talk migration) that are holding up some work, but voting/rating/etc are probably next. Likely something we do and deploy in early 2012.Mon, 03 Oct 2011 07:55:33 GMTSteve Jones - SSC EditorRE: Closing Out Replieshttp://www.sqlservercentral.com/Forums/Topic1183531-263-1.aspx[quote][b]Matthew Joughin (9/29/2011)[/b][hr]I would say the way pioneered by www.StackOverflow.com is the best way, where responses are voted for, but you can only vote for a response if you have "credibility".So then the person who finds the question later has a good indication of which the correct responses. I have found this works very well, and in fact have yet to find a question posted on Stackoverflow, which has voted answers, that didn't work as per the most voted answer!They have a api called StackExchange which allows anyone to set up the same type of site, perhaps that should be looked into...[/quote]Which of course has problems with the definition of "credible". I'm probably pretty credible on coding and performance tuning, since I do a lot of that, but I'm far from credible on a number of other things in SQL Server, and partially credible on other things.So, does that mean I would get to "vote" only on certain posts? Would Gail's votes count more than mine on some posts (since she's definitely more credible on certain subjects)? How about Joe Celko? He's got credibility on certain things, and is dead wrong on others, even ignoring his tendency to do his best to be rude and arrogant. What does he get to vote on? How much do his votes count? Jeff Moden is highly credible on a number of SQL subjects, but I've seen him "vote", in effect, against SSIS solutions that were perfectly valid, just because he personally dislikes SSIS. Same for CLR solutions. He's come around a bit on those recently, but check some of his posts from last year even, on either of those subjects.Which brings up, what happens if some credible expert votes for something, and five minutes later is told a better solution by someone who's completely new to the site, tests it, and finds out their solution is better? I've seen that happen numerous times.The Stack Overflow solution has positive factors, but it also has negative ones, and some of them are eggregiously negative. There are a lot of high-vote solutions on there that are valid but far from optimum. Some because they were optimum at the time they were voted for, but no longer are, others for other reasons.Fri, 30 Sep 2011 07:41:00 GMTGSquaredRE: Closing Out Replieshttp://www.sqlservercentral.com/Forums/Topic1183531-263-1.aspx[quote][b]Matthew Joughin (9/29/2011)[/b][hr]They have a api called StackExchange which allows anyone to set up the same type of site, perhaps that should be looked into...[/quote]You mean like this: [url]http://ask.sqlservercentral.com/[/url]The problem with that is that it's the popular answer that gets the votes, not necessarily the right one. I've seen SQL-related questions where the most votes were for a simple-looking, elegant solution that would work fine on a couple hundred rows and die a slow, agonising death on a few hundred thousand. There were answers warning about the performance implications, but they had few-no upvotes and even some downvotes (probably because they were more complex)Fri, 30 Sep 2011 00:17:22 GMTGilaMonsterRE: Closing Out Replieshttp://www.sqlservercentral.com/Forums/Topic1183531-263-1.aspxI would say the way pioneered by www.StackOverflow.com is the best way, where responses are voted for, but you can only vote for a response if you have "credibility".So then the person who finds the question later has a good indication of which the correct responses. I have found this works very well, and in fact have yet to find a question posted on Stackoverflow, which has voted answers, that didn't work as per the most voted answer!They have a api called StackExchange which allows anyone to set up the same type of site, perhaps that should be looked into...Thu, 29 Sep 2011 23:25:25 GMTMatthew JoughinClosing Out Replieshttp://www.sqlservercentral.com/Forums/Topic1183531-263-1.aspxComments posted to this topic are about the item [B]<A HREF="/articles/Editorial/76271/">Closing Out Replies</A>[/B]Thu, 29 Sep 2011 23:21:06 GMTSteve Jones - SSC Editor