The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

1 New comments should promote questions back up the Active & Hot lists

2 No down-votes At the moment we are all playing nicely here, however once the new SQLA becomes the default public forum things may change. Those who use Stack Overflow and the like will have seen how perfectly reasonable questions and answers can get down-voted when some of the more self-satisfied users decide that they are too stupid / easy / obvious etc. Even a few down-votes could discourage a new user from using the site again.

While I'm no great believer in the "all must have prizes" school of thought, there seems little to be gained for the community in denigrating someone's honest contribution. By all means comment on it or correct it, but simple down-voting seems to me to be against the spirit of THIS site.

Spamming and frequent off-topic questions and answers would be better dealt with by moderation.

asked 20 Sep '10, 18:19

Justin%20Willey's gravatar image

Justin Willey
accept rate: 20%

closed 27 Mar '11, 15:53


Thanks for your suggestions. I believe #1 has already been implemented. While I agree with the idea of #2, perhaps we could allow downvotes on community wiki posts so that polls like the one Mark posted ( would still work.

If anyone else has suggestions, please post them as answers to this question, and make sure to upvote your favourites!

(20 Sep '10, 18:50) Graeme Perrow

I agree with Volker's sentiment (be polite etc) but I don't think SQLA will EVER be like Stack Overflow... so I say "let's wait until we see a problem before taking the drastic action of #2"... or have you seen a problem already?

(20 Sep '10, 20:43) Breck Carter

I agree that I don't like down votes, even on polls. The down votes on the poll that I posted has skewed the results so that I (we) can't really tell how many votes went to each option :-( It would be better to not allow down votes at all, or if they are allowed then separate out the tally of up and down votes. I.e. show two numbers: total of up votes and total of down votes. But I think simpler is better so just disallow them completely. What do others think? SQLA is a community based forum so we should do what the community wants.

(21 Sep '10, 01:36) Mark Culp

I think you already have two choices: You can up-vote or not-vote, so expressing your support for a question, answer or comment is possible. So down-votes are not needed.

(21 Sep '10, 07:40) Martin

@Breck: Though I try to be polite, too, it is Justin's suggestion:)

(21 Sep '10, 07:54) Volker Barth

I agree with Breck that this is not (yet) a problem and should be watched for but not (yet) regulated. Interstingly enough, Mark's poll has "bagded" several members as "critics" - that seems not senseful for a poll. However, with this particular poll, I deliberately used both up-votes, down-votes and "no votes" to express three different opinions: "I prefer this", "I am against this" and "I don't mind". As such, a down-vote has its use IMHO.

(21 Sep '10, 08:05) Volker Barth

@Volker: Doh! Advancing age is my excuse and I'm sticking to it! :)

(21 Sep '10, 08:30) Breck Carter

@Breck - No, not seen any problem here - but I was searching for something on SO and noticed some of the behaviour there - not that I'm suggesting that SQLA users would ever behave like some SO users do - all together a more superior kind of ....etc :) I sure that some people will have one try at SO and never go near it again,.

(21 Sep '10, 10:12) Justin Willey

@Mark: On Stack Overflow, users with enough reputation (1000+) can click on the "score" of a question or answer and see exactly how many upvotes and downvotes it has received. So instead of "10" you might see "+12 / -2". I'm sure we can add this as well, if it's not already there.

(21 Sep '10, 14:47) Graeme Perrow
Comment Text Removed

I've up voted this for point one and down voted it for point two :)

I think been able to down vote is an important way for the users to moderate the site. I realise some people might get a bit precious about others down voting their comments but we're all adults so I'm sure we can take a bit of criticism, especially as it's usually helpful and friendly on here ?

Mind you this comment is totally useless because of point one :)

(13 Nov '10, 00:29) Daz Liquid
More comments hidden
showing 5 of 10 show all flat view

The question has been closed for the following reason "Other" by Justin Willey 27 Mar '11, 15:53

Don't move a question into the "hot" or "active" lists just because someone has edited the tags.

In some cases, someone will edit a LOT of questions in a global-tag-edit (like I just did adding "olap" to everything that talks about the WINDOW clause), and now they all appear at the top of the list.

permanent link

answered 26 Sep '10, 11:02

Breck%20Carter's gravatar image

Breck Carter
accept rate: 21%


Agreed:) I think it's inappropriate that re-tagging is treated as editing, particularly the fact that the question is listed with the re-tagger (and not the original poster) as user in the question list. - I do re-tag now and then (and feel there's some sense in that) but I don't feel I have contributed anything important to the question itself.

(26 Sep '10, 14:05) Volker Barth

I would like to also see better syntax highlighting/formatting of posted SQL code. Right now there are a ton of keywords that aren't recognized by the highlighter in Stack Overflow/Exchange.

permanent link

answered 25 Sep '10, 23:50

Calvin%20Allen's gravatar image

Calvin Allen
accept rate: 25%


I agree. I use Alex Gorbatchev's SyntaxHighlighter in my blog but only in "plain text mode" because the SQL highlighting does not work well for SQL Anywhere. It is JavaScript, and customizable, but I didn't have any luck... Mark could probably make it work in five minutes!

(26 Sep '10, 09:09) Breck Carter

It does seem strange using something called "SyntaxHighlighter" in plain text mode... but it offers many features beyond highlighting, like line numbering and wrapping and copy and paste.

(26 Sep '10, 09:11) Breck Carter

See my comment on Breck's suggestion:

Possibly an editor could have an option to mark the edit as "important" or "not" (as is possible in certain wiki systems, e.g. PmWiki).

That would help to "hide" simple edits (as re-tagging or correcting typos) from relevant ones where new/corrected contents has been added and other users should get attracted by placing the question at the top of the list.

The same might be useful for adding comments w.r.t. to the question whether the according question should be posted on top: Adding a simple "I agree" or some funny remark should possibly not mark the question as "changed" whereas a comment like "I strongly disagree because..." should.

Though it might be less obvious how to decide that personally for comments - one usually writes something with the hope to get read...

permanent link

answered 26 Sep '10, 14:08

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

edited 27 Sep '10, 12:30


Maybe have a subset of edit reasons that the user has to choose from, and then that would dictate when to 'promote' the question back to the top?

(26 Sep '10, 18:45) Calvin Allen

I would like to see a watch list per user. So that a question which one might be interested in remains in the focus.

permanent link

answered 12 Nov '10, 14:50

Martin's gravatar image

accept rate: 14%


You do have the favorites list which is made for this purpose. If you click on the star underneath the score of a question, it gets added to your favorites list. You can see your favorites list by clicking on your name and then clicking "Favorites". It does not, however, affect the list of questions you see on the main page.

(12 Nov '10, 17:59) Graeme Perrow

Thanks, I didn't understand that this feature is a "personal" favorite

(15 Nov '10, 08:29) Martin

For Mark: What a pity that SQLA2 has no taxonomist bagde anymore - now that even a meta-taxonomist bagde seems appropriate for your current task:)

permanent link

answered 18 Mar '11, 12:56

Volker%20Barth's gravatar image

Volker Barth
accept rate: 32%

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 20 Sep '10, 18:19

question was seen: 1,439 times

last updated: 27 Mar '11, 15:53