Into

• Molecular Biology

• RDBMS

My avatar (a mantis shrimp), my favourite metazoan! They have the most complex eyes which are mounted on stalks and can move independently of each other (cool or what?)! They have 12-16 photoreceptor cell types (we have 3!).

--

Q&A:

GOOD questions tend to get good answers (and vice versa).

BEFORE asking a question, have you:

• taken the tour (< 1 minute)?
• grasped the dba.se Zeitgeist (what's it's all about ~ 15 mins)?
• checked that your question is on-topic (< 1 minute)?

To ask a good question please look here:

• Aaron Betrand (top on dba.ie)
• Another dba one

• a good witty overview.

• the MVCE - Minimum, Complete and Verifiable Example. See also the Short, Self Contained, Correct (Compilable), Example site.

• for performance queries.

• more helpful ideas here and here.

• the granddaddy of all "How to ask for help" posts by Eric Raymond.

• To be avoided!

Below here is a Work in Progress!

Query Performance questions:

SQL

https://meta.stackoverflow.com/questions/271055/tips-for-asking-a-good-structured-query-language-sql-question/271056#271056

General:

https://dba.stackexchange.com/tags/postgresql-performance/info https://dba.meta.stackexchange.com/questions/3034/asking-query-performance-questions

PostgreSQL:

PostgreSQL oriented, but definitely worth a look.

SQL Server:

https://www.brentozar.com/archive/2009/03/getting-help-with-a-slow-query/

Answers:

There are surprisingly few good links on how to answer technical questions - I'll leave the final word on answering to the man who has > 1M points on StackOverflow.