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 ...
Erik Darling's user avatar
  • 38.8k
30 votes

Community Promotion Ads - 2018

LowlyDBA - John M's user avatar
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. ...
McNets's user avatar
  • 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 White's user avatar
  • 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 ...
Brent Ozar's user avatar
  • 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.
ypercubeᵀᴹ's user avatar
24 votes
Accepted

Should we change the formatting of backtick markdown elements?

No - it is just fine as it is.
Paul White's user avatar
  • 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

Community Promotion Ads - 2018

Jack Douglas's user avatar
  • 39.7k
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 White's user avatar
  • 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 ...
Philᵀᴹ's user avatar
  • 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 White's user avatar
  • 83k
22 votes

Community Promotion Ads - 2018

Aaron Bertrand's user avatar
  • 180k
22 votes

Community Promotion Ads — 2019

Jack Douglas's user avatar
  • 39.7k
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 ...
Jack Douglas's user avatar
  • 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 White's user avatar
  • 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 ...
ypercubeᵀᴹ's user avatar
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

Community Promotion Ads - 2016

Aaron Bertrand's user avatar
  • 180k
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 White's user avatar
  • 83k
20 votes

Community Promotion Ads - 2017

Aaron Bertrand's user avatar
  • 180k
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 ;)
ypercubeᵀᴹ's user avatar
19 votes

Community Promotion Ads - 2016

Brent Ozar's user avatar
  • 42.7k
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

Community Promotion Ads - 2017

Jack Douglas's user avatar
  • 39.7k
19 votes

Community Promotion Ads — 2019

LowlyDBA - John M's user avatar
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 ...
John K. N.'s user avatar
  • 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 ...
Jack Douglas's user avatar
  • 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 White's user avatar
  • 83k

Only top scored, non community-wiki answers of a minimum length are eligible