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, ...
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
- 90.3k
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 WhiteMod
- 90.3k
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 WhiteMod
- 90.3k
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 ...
- 31.6k
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 ...
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 WhiteMod
- 90.3k
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,...
- 64.7k
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.
- 64.7k
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 WhiteMod
- 90.3k
5
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 ...
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 ...
- 25.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 ...
- 15.7k
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 ...
- 70.5k
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, ...
2
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
...
Only top scored, non community-wiki answers of a minimum length are eligible