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 ...
- 36.7k
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.2k
29
votes
Are licensing questions within our scope?
Personally, I think this is dangerous to allow. Licensing is a vast landscape and there are mines everywhere. Being out of compliance is something that can get you and your company into serious hot ...
Aaron BertrandStaff
- 178k
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
- 78.6k
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.4k
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.
- 95.5k
25
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, ...
24
votes
Accepted
Should we change the formatting of backtick markdown elements?
No - it is just fine as it is.
Paul WhiteMod
- 78.6k
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
Accepted
Why is dba.stackexchange so...welcoming?
As a lower-volume site compared to, say, Stack Overflow, we're able to manage behavior much more reliably, and we just don't get a lot of the nonsense that is inevitable with higher volume. We're also ...
Aaron BertrandStaff
- 178k
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
- 78.6k
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.3k
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
- 78.6k
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 ...
- 38.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
- 78.6k
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 ...
- 95.5k
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
- 78.6k
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 ;)
- 95.5k
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
Are SQL Challenges On Topic?
Yes, SQL Challenges should be considered on topic because...
they provide the community with new approaches to existing problems.
they show the more exotic forms of SQL, and are an invaluable way to ...
19
votes
Accepted
Should MySql be tagged as 'oracle'?
I think the wording in the tag description is confusing. I have always believed the oracle tag to be reserved for questions about a specific product called Oracle Database. Now I am not a native ...
- 22.3k
Only top scored, non community-wiki answers of a minimum length are eligible