Skip to main content
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
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.8k
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
  • 85.7k
27 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

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
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
  • 85.7k
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
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
  • 85.7k
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.8k
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
  • 85.7k
22 votes

Community Promotion Ads - 2018

Aaron Bertrand's user avatar
  • 181k
22 votes

Community Promotion Ads — 2019

Jack Douglas's user avatar
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
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
  • 85.7k
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
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
  • 85.7k
20 votes

Community Promotion Ads - 2017

Aaron Bertrand's user avatar
  • 181k
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

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
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.9k
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
  • 85.7k
18 votes
Accepted

Disclosures, every post/comment or is profile enough?

If your answer tends to promote usage of a product, website, or technology where the you stand to benefit from that usage, then a disclosure (thanks, @AndriyM) should be added to the post. Adding ...
Hannah Vernon's user avatar
  • 70.1k
18 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 ...
18 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 ...
Andriy M's user avatar
  • 23k

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