Vérace
Into
Molecular Biology
Databases (RDBMS)
My avatar is a worm (C. elegans) expressing GFP.
--
Questions (and answers): (Help us to help you!)
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.
the granddaddy of all "How to ask for help" posts by Eric Raymond.
Below here is a Work in Progress!
Query Performance questions:
SQL
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.
-
Contae Átha Cliath, Éire.
-
Member for 6 years, 9 months
-
2 profile views
-
Last seen Nov 13 '19 at 21:20
Communities (19)
- Database Administrators 21.9k 21.9k 44 gold badges4747 silver badges6666 bronze badges
- Stack Overflow 501 501 55 silver badges3131 bronze badges
- French Language 483 483 44 silver badges1414 bronze badges
- Unix & Linux 457 457 44 silver badges1616 bronze badges
- English Language & Usage 154 154 66 bronze badges
- View network profile
Top network posts
- 98 Difference between On Delete Cascade & On Update Cascade in mysql
- 71 How to check foreign keys related to a table
- 59 Export Postgres table as json
- 32 Why should a key be made explicit?
- 21 How to add a column with a foreign key constraint to a table that already exists?
- 14 Is a single-table relational database similar to a simple NoSQL database?
- 13 ERROR 1148: The used command is not allowed with this MySQL version
- View more network posts →
Keeping a low profile.
This user hasn't posted yet.