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
- 82.9k
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 WhiteMod
- 82.9k
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
- 82.9k
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
- 82.9k
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 ...
- 31k
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 ...
- 69.7k
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 ...
- 38.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 WhiteMod
- 82.9k
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,...
- 62.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 WhiteMod
- 82.9k
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.
- 62.1k
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 ...
- 24.7k
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.6k
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 ...
- 69.7k
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