Into

• Molecular Biology

• RDBMS

My avatar is 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!).

--

Questions (and answers):

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 poster here - dba.se specific)
• 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.

• Avoid!

Below here is a Work in Progress!

Query Performance questions:

SQL

Tips for asking a good Structured Query Language (SQL) question

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.