Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Closing Out Replies Expand / Collapse
Author
Message
Posted Thursday, September 29, 2011 11:21 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:17 AM
Points: 31,080, Visits: 15,526
Comments posted to this topic are about the item Closing Out Replies






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1183531
Posted Thursday, September 29, 2011 11:25 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 2, 2012 12:22 PM
Points: 13, Visits: 145
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...


if you don't have the time to do it right, when will you have the time to do it over ?
Post #1183532
Posted Friday, September 30, 2011 12:17 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 7:50 AM
Points: 39,977, Visits: 36,339
Matthew Joughin (9/29/2011)
They have a api called StackExchange which allows anyone to set up the same type of site, perhaps that should be looked into...


You mean like this: http://ask.sqlservercentral.com/

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)



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1183541
Posted Friday, September 30, 2011 7:41 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
Matthew Joughin (9/29/2011)
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...


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.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1183744
Posted Monday, October 3, 2011 7:55 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 7:17 AM
Points: 31,080, Visits: 15,526
Matthew Joughin (9/29/2011)
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...


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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1184551
Posted Tuesday, October 4, 2011 12:13 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, August 21, 2014 1:54 PM
Points: 1,430, Visits: 3,229
GSquared (9/30/2011)

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.


Well stated Sir.




The probability of survival is inversely proportional to the angle of arrival.
Post #1185425
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse