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


Closing Out Replies


Closing Out Replies

Author
Message
Steve Jones
Steve Jones
SSC Guru
SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)

Group: Administrators
Points: 141934 Visits: 19420
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
My Blog: www.voiceofthedba.com
Matthew Joughin
Matthew Joughin
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
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 ?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)SSC Guru (216K reputation)

Group: General Forum Members
Points: 216117 Visits: 46276
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, MVP, M.Sc (Comp Sci)
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


GSquared
GSquared
SSC Guru
SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)SSC Guru (55K reputation)

Group: General Forum Members
Points: 55701 Visits: 9730
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
Steve Jones
Steve Jones
SSC Guru
SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)SSC Guru (141K reputation)

Group: Administrators
Points: 141934 Visits: 19420
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
My Blog: www.voiceofthedba.com
sturner
sturner
SSCarpal Tunnel
SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)SSCarpal Tunnel (4.9K reputation)

Group: General Forum Members
Points: 4922 Visits: 3259
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search