84
votes
Accepted
Help me write this query in SQL
Howdy© and Welcome aboard®!
We're glad you chose dba.stackexchange.com for assistance with your homework a production emergency writing your non-trivial query.
When you need help writing a Query From ...
- 38.8k
30
votes
30
votes
It has been a great privilege to serve this amazing community as moderator. Thank you
Jack, first forgive my English, is not as fluent as I would like.
I don't know you personally, I've been in this community for 2 years and 11 months, and we have regularly met in the chat room.
...
- 23.6k
28
votes
Accepted
Why are users correcting my British English answers to the American spelling?
Is there a rule where the spelling of answers has to be in "American"?
No. See What should the standard spelling be - British or US?
From that meta Stack Exchange Q & A's accepted answer by a ...
Paul WhiteMod
- 83k
26
votes
Is there any way to fix reputation mechanics here?
I'm going to give you some public tough love, but only since you asked.
Your answers aren't actually all that good.
Take this one: Will DB session terminate when client close DB connection
The ...
- 42.7k
26
votes
Asking query performance questions
As many of the following as possible:
Formatted text of the query/procedure/function.
Indenting SQL by 4+ spaces on each line is usually best.
Schema (CREATE TABLE); use text, not images
Table, ...
26
votes
It has been a great privilege to serve this amazing community as moderator. Thank you
It's a sad day for Database Administrators.
- 97.4k
24
votes
Accepted
Should we change the formatting of backtick markdown elements?
No - it is just fine as it is.
Paul WhiteMod
- 83k
24
votes
Burninate the [dba] and [database-administration] tags?
Yes dba should be burninated because it...
Isn't useful to connect experts in a topic area to questions they can answer
Doesn't help describe the content of the question
Doesn't add any meaningful ...
24
votes
23
votes
Suggestions for a better headline graphic
Based on Crow's Foot notation:
Symbol reference:
image source
Intended meanings as drawn (artistic licence employed):
One (and only one) Database Administrators site
Many questions
Zero or many ...
Paul WhiteMod
- 83k
23
votes
It has been a great privilege to serve this amazing community as moderator. Thank you
Jack, as the person that thanked me for my first few answers & encouraged me to join The Heap, I'd like to thank you for the time you have invested in DBA.se & also for the work you have put ...
- 31.6k
22
votes
Accepted
Do we accept database comparison questions or are they offtopic?
These types of questions are harmful to the site and should be quickly closed and probably deleted.
I know that SO has a no-shopping-list questions policy, and this feels like a shopping-list.
It'...
Paul WhiteMod
- 83k
22
votes
22
votes
21
votes
Should we change the formatting of backtick markdown elements?
It is jarring, but taking the background colour away entirely leaves it hard to tell what is code and what isn't:
I think we should consider a third option, ether a lighter grey:
Or ...
- 39.7k
21
votes
I have selected an answer, but my requirements have changed
Ask a new (follow-up) question, including a link to the previous one if it provides useful context. The new question should still make sense on its own, of course.
As a general rule, it is better to ...
Paul WhiteMod
- 83k
21
votes
Is there any way to fix reputation mechanics here?
Before going into the question, I'll address two of your comments under the question and answers because I feel they show your thinking:
@user you say that you hold yourselves to a higher standard ...
- 97.4k
21
votes
Accepted
Is the comment-only answer acceptable?
No
Questions that are trivial enough to be answered in this way are too simple for dba.se and should be closed.
If it does warrant a full answer, posting the answer as a comment makes the solution ...
20
votes
20
votes
Accepted
Are two answers by a single person on one question A Good Thing™?
Related meta.SE question:
What is the official etiquette on answering a question twice?
My own view is that it should be pretty unusual to see multiple answers by the same author, but it can be ...
Paul WhiteMod
- 83k
20
votes
20
votes
Is this ageism or acceptable humour?
Personal opinion: I found it funny.
(Note: I'm old enough to be that DBA. I have several books with weird covers. I also read them. I'm sure a lot of what I say sounds weird to younger people ;)
- 97.4k
19
votes
19
votes
Burninate the [dba] and [database-administration] tags?
Yes database-administration should be burninated because it...
Isn't useful to connect experts in a topic area to questions they can answer
Doesn't help describe the content of the question
Doesn't ...
19
votes
19
votes
19
votes
It has been a great privilege to serve this amazing community as moderator. Thank you
Even though we didn't have that much of an exchange (except for the dozens of chat messages regarding oracle and rman and incarnation and ora-600) I will really miss you as a very moderate moderator ...
- 17.4k
18
votes
Accepted
I don't think the votes on my answer are merited
Should I leave it at that or should a mod revert some of the votes.
I think you should just leave it at that — and not just because mods can't revert votes or even tell who voted for you, also ...
- 39.7k
18
votes
Accepted
Policy Change : Disallow unregistered users from asking/answering questions?
From my own perspective of site moderation for a period of time now:
I can say my strong impression is that questions from unregistered users are much more often lower-quality, and not improved on ...
Paul WhiteMod
- 83k
Only top scored, non community-wiki answers of a minimum length are eligible