Suggestion for points

Question

Post reply

Suggestion for points

michael.lemr

SSC Enthusiast

Points: 174
More actions
July 12, 2010 at 3:40 pm

#223760

Oracle's support forum recently added a good idea - allowing the person that posts a question to award 5 points for helpful answers, and 10 for a single correct answer. Helps those who really know the answers stay ahead of those that just guess at everything.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

That sort of system is in use at ask.sqlservercentral.com

It is not exactly as you listed, but the same principle.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 2

We have debated that here, and might. It's a somewhat long process to get it well integrated, and likely we'd want to scale our points up in other areas as well. It's a good suggestion.

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 3

Heh... who's going to decide what a good answer is... the Original Poster? Let me tell you some of the reasons why that's such a bad idea...

1. Despite their best intentions, the original posters do NOT have the qualifications to decide if an answer is actually a good answer. If they were, they probably wouldn't have had to post the question to begin with. No offense meant to anyone... it's just a fact.

2. All too often (I've seen it a huge number of times on ASK.SSC), someone will very quickly post a "correct" answer on the site. A "correct" answer usually means that it satisfies the Original Poster's immediate need. The code, however, is frequently performance challenged and non-scalable and, in no way, should the code ever actually be allowed near a computer, but it does solve the OP's problem and the OP gives it a 10.

Then, someone who takes a bit more time to create, test, and post a bit of code that not only returns the correct answer but is also highly scalable and has great performance. This person also posts a performance comparison between the first code (which is actually horrible but got the 10 because the OP didn't know any better) and his own code.

Now what do you do?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)