I think it depends on how the question is worded. This is always how I decide whether I vote to close or not. A lot of the time, people say they have a code snippet (usually something they haven't even written themselves) and then go on to mention it doesn't work and ask what the solution is. This I do not like as it shows no effort.
If the user has started writing some code, for example a database query. They provide us detail with exactly what they're trying to do along with what they have already tried themselves, then this IMO is perfectly fine.
The question asked in the link you provided I believed was a fair valid question, due to the way it was worded, it fairly description and some effort was shown. This IS however my own opinion so people may disagree with me.
On Stackoverflow, there are thousands of question pending review for being closed. I've noticed a lot of people simply review for the sake of it without actually reading the question. However I believe the Joomla SE site will be very different in the way things are handled as I have noticed a lot by peoples comments on questions for the Joomla tag on SO.