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


Member should be able to mark post as "Answered".


Member should be able to mark post as "Answered".

Author
Message
Rohit Khare
Rohit Khare
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 71
I feel without marking a post as "Answered", it always doubtful whether the answer submitted proved useful or not.

My suggestion is to have a top-level category: Answered. There can be two or more correct answers, so the member should be able to mark:

- Best Answer
- Alternate

or something like that.

======================================
Blog: www.irohitable.com
GilaMonster
GilaMonster
SSC Guru
SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)

Group: General Forum Members
Points: 221562 Visits: 46281
If you search through the suggestion forum, this comes up every 6 months or so.

What is the 'best answer'? One of the first rules about SQL is that there's seldom one best answer for all cases.
Who decides if a solution is correct? The person asking the question can't, if they knew what the correct answer was, they wouldn't be asking the question.
What happens when the OP follows some utterly dangerous advice without realising it, marks that very dangerous advice as 'The Correct Answer' then goes away (because he's happy) and a few hours later some other people come along to correct the advice, but the very dangerous solution remains marked as 'The Correct Answer'

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


Rohit Khare
Rohit Khare
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 71
The person asking the question will come to know whether the answer is correct or not by trying out and seeing the output. This is applicable to forums where the answer depends on the output.

I also partially agree with you on who will decide the Best Answer. For this I'd like to say that the top contributors will decide the best answer. You can set a point limit, like Stack Overflow. Only members above certain point level can decide best answer. The person who asked the question can only mark the post as Answered.

At present, the visitors have to watch and read each and every answer. If the question is marked "Answered", the visitor can immediately determine which answer was close enough.

======================================
Blog: www.irohitable.com
GilaMonster
GilaMonster
SSC Guru
SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)

Group: General Forum Members
Points: 221562 Visits: 46281
Rohit Khare (4/21/2012)
The person asking the question will come to know whether the answer is correct or not by trying out and seeing the output.


So, let's say there's a question is about handling a full transaction log.
The first reply says to detach the database, delete the log and reattach the database. The OP tries that and it works. Should that be marked as the answer? It'll sometimes do what the question asks. It'll sometimes destroy your database beyond recovery.

Take a dev question. Someone asks for a query that produces a particular output. Someone posts a solution that works, but it not guaranteed to work in all circumstances (depends on behaviour that's not consistent), however the person posting it doesn't say that (may not even know). The OP tries it in a test environment and it works. Should that be marked as the answer (given that it might not work in all cases)

Debate and discussion is one of the things we encourage here. If you want a 'marked as answer', 'top voted post' mechanism, we have stack-overflow site as well for those who prefer that mechanism http://ask.sqlservercentral.com

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


Rohit Khare
Rohit Khare
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 71
Each forum has its own plus and minus. Stack Overflow is not dedicated to SQL Server but a common platform to ask any type of questions.

Any forum answer is not guaranteed to work in all scenarios. The scenario may not have been disclosed by the person asking the question.

Anyway, it is just a suggestion. Accepting or rejecting it is up to you.

======================================
Blog: www.irohitable.com
GilaMonster
GilaMonster
SSC Guru
SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)SSC Guru (221K reputation)

Group: General Forum Members
Points: 221562 Visits: 46281
Rohit Khare (4/21/2012)
Each forum has its own plus and minus. Stack Overflow is not dedicated to SQL Server but a common platform to ask any type of questions.


I didn't suggest stack overflow as an alternative. I said we have a stack overflow-type SQL board here for those who prefer the 'marked as answer', 'top-voted post' style over discussion forums at http://ask.sqlservercentral.com

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


Rohit Khare
Rohit Khare
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 71
Ok. That's good.

======================================
Blog: www.irohitable.com
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