79 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 ...
user avatar
  • 34.2k
30 votes

Community Promotion Ads - 2018

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. ...
user avatar
  • 22.9k
28 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 ...
user avatar
  • 177k
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 ...
user avatar
  • 72.1k
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 ...
user avatar
  • 41.4k
25 votes

It has been a great privilege to serve this amazing community as moderator. Thank you

It's a sad day for Database Administrators.
user avatar
24 votes
Accepted

Should we change the formatting of backtick markdown elements?

No - it is just fine as it is.
user avatar
  • 72.1k
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

user avatar
  • 37.6k
24 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, ...
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 ...
user avatar
  • 177k
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 ...
user avatar
  • 72.1k
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 ...
user avatar
  • 30.9k
22 votes
Accepted

MSSQL vs SQL Server

Thanks for bringing this up on meta so constructively. The consensus here is that we use the term 'SQL Server' and not MSSQL - it might not always merit an edit just to make that change but it's ...
user avatar
  • 37.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'...
user avatar
  • 72.1k
22 votes

Community Promotion Ads - 2018

user avatar
  • 177k
22 votes

Community Promotion Ads — 2019

user avatar
  • 37.6k
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 ...
user avatar
  • 37.6k
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 ...
user avatar
  • 72.1k
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 ...
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

My reviewing of questions is declared "blatantly bad"; why, and how can I improve?

We do have issues with folk sometimes doing pointless edits or putting in minimal effort because they are after a badge or something, so we sometimes get a bit trigger-happy. In this case, I think you'...
user avatar
  • 37.6k
20 votes

Community Promotion Ads - 2016

user avatar
  • 177k
20 votes

Community Promotion Ads - 2017

user avatar
  • 177k
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 ;)
user avatar
19 votes

Community Promotion Ads - 2016

user avatar
  • 41.4k
19 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 ...
user avatar
  • 72.1k
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

user avatar
  • 37.6k

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