Mangal Pardeshi (3/4/2009)
But what about someone who is new on forums? How will he/she will come to know about poor advise? By the time he/she realizses damage might have done already.
However there's nothing stopping people marking very bad advice (and there is some of that around here) as the answer and in that case having an 'accepted answer' makes matters worse, not better.
- What is the business requirement? (I know this valid question - but everytime? without providing any alternative?)
Sometimes the reason for the request is not clear and when it is it's easy to see that there's a better solution.
It's like someone asking "What tool do I use to cut Teak?" You can answer "An Axe", but asking what he's doing may reveal that he's carving expensive furniture, in which case an axe is not the appropriate tool.
- Look for "Something" in Books online
Personally I have better things to do with my time than retyping a portion of Books Online when I know the answer is in there. (and I know I'm one of those you're getting at here)
- Check out the Arcticle by ---
See above. Someone has gone to a lot of trouble to write out a detailed article on something. Is my 2 min quick answer likely to come close to that?
- Or simple providing some bunch of links
See above. If it's been answered elsewhere, why spend time answering it again when that time can go to helping someone who's question doesn't have an existing answer.
I often point people to my blog. Why? Because when I see a certain question getting asked a lot here (parameter sniffing, bookmark lookups, etc), I write a blog post on it and go into a fair bit of depth. That way, the next time the question gets asked, there's a detailed post, with examples written.
- And best one why do you need to do this?
Same as asking for the business requirement. Sometimes the reason for the request is not clear and when it is it's easy to see that there's a better solution.
Do bear in mind that no one here (other than Steve) works for SQL Server Central. We're all posting in our free time, which is getting more and more limited each day.
Number of posts "Answered" is any time better than just Number of posts.
You'll probably find, after some time, that most of the people with the top post count will also have the highest "answered" number too.
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