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, ...
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
  • 84k
15 votes
Accepted

Would question about database recommendation be on topic?

database-recommendation questions are not off-topic, but experience has shown that they need to be better than average to avoid being ignored or closed, especially in recent times. Click on that tag ...
Paul White's user avatar
  • 84k
12 votes

What's wrong with this database recommendation question?

I edited and upvoted your question because I found it on-topic and interesting. That said, other members of the community had already voted to close it, and left it closed after an automatic reopen ...
Paul White's user avatar
  • 84k
11 votes
Accepted

Should we create a "what is meltdown/spectre and will it impact my SQL servers" question?

This could be a useful Q & A, though a bit broad by our usual standards. Seems like it might be a good candidate for a Wiki Answer (like Where to start with Oracle?): This question's answer is ...
Paul White's user avatar
  • 84k
9 votes
Accepted

Minimal, Complete, and Verifiable Example

How to create a Minimal, Complete, and Verifiable Example for database-related questions Database-related questions asking for practical advice will get the most helpful answers if they provide a ...
8 votes
Accepted

How to ask a question when unable to reveal table data/structure

I think you can easily reduce your example (including renaming tables/columns) to something that does not reveal anything about the real DB you are working with. The same applies in most cases to the ...
András Váczi's user avatar
8 votes

Would question about database recommendation be on topic?

Questions about how to circumvent licensing restrictions are off-topic, for obvious legal reasons. However, you're welcome to ask for database recommendations, just make sure your question is clearly ...
Hannah Vernon's user avatar
  • 70k
8 votes
Accepted

Helping new users write good questions

Chit Chat The main problem isn't one that a one on one chat can easily solve, given all the different time zones, languages, and time constraints placed on both participants. We've all been there ...
Erik Darling's user avatar
  • 40.8k
8 votes
Accepted

How to add conclusive information to a question - after it has been answered?

The question author adding a "conclusion" is a bit of an odd thing that does not naturally fit in Q & A format. Nevertheless, on the odd occasion the question author strongly feels this sort of ...
Paul White's user avatar
  • 84k
7 votes

Helping new users write good questions

I don't think it's a bad idea, but I wouldn't be willing to participate in the one-on-one. The thing about DBA.se is that I'm usually helping out more than one person in the process of using this site,...
Evan Carroll's user avatar
  • 63.1k
6 votes

Should Stack Overflow provide hints on asking at DBA?

In principle, I'm in favour of anything that means people ask in the right place* Whether this particular idea is a good one depends on the details of the implementation, and how accurately any AI ...
Paul White's user avatar
  • 84k
6 votes

Asking query performance questions

Instructions for PostgreSQL Performance Questions Copied from the postgresql-performance tag info. About improving / explaining the performance of existing queries. May concern particular query ...
6 votes

Possible to Optimize Based on DB Structure Only - No Data

Questions about improving performance should include: The full text of the query. SQL CREATE statements for the tables and indexes involved Use SHOW CREATE TABLE\G The version of the product you are ...
6 votes

Should we create a "what is meltdown/spectre and will it impact my SQL servers" question?

NEVER ASK TO ASK. JUST ASK If the question is bad, it'll get downvoted or closed at worst.
Evan Carroll's user avatar
  • 63.1k
4 votes

What's wrong with this database recommendation question?

I didn't vote to close, mainly because I didn't see this question in the review queue. I'm not sure what I would have done if I did. After the edits it's probably not unclear, even if it's a domain ...
Tom V's user avatar
  • 15.7k
4 votes

Helping new users write good questions

This is a really nice, welcoming idea. I struggled with the mechanics of this app initially (still do TBH). I imagine I'm typical in that. However. I have a full time job. And a family. And a life. I ...
Michael Green's user avatar
3 votes

Asking query performance questions

Taken from a comment by Wilson Hauck on a MySQL performance issue question. Instructions for MySQL Performance Questions Computer specifications RAM size SSD/NVME versus HDD on MySQL Host server ...
3 votes

What's wrong with this database recommendation question?

I was the first person to vote to close your question. I did that because I felt the question was unclear because it did not address what you meant by modifying the order of a linked-list without ...
Hannah Vernon's user avatar
  • 70k
3 votes

Update of FAQ question "How do I ask a good question"

This answer is community wiki please provide additional database-specific information at the bottom. Formatting When possible do not include screenshots or pictures where text would otherwise do, ...

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