Hot answers tagged

84 votes
Accepted

Help me write this query in SQL

Howdy© and Welcome aboard®! We're glad you chose dba.stackexchange.com for assistance with your homework a production emergency writing your non-trivial query. When you need help writing a Query From ...
Erik Darling's user avatar
  • 40.5k
27 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, ...
22 votes
Accepted

Do we accept database comparison questions or are they offtopic?

These types of questions are harmful to the site and should be quickly closed and probably deleted. I know that SO has a no-shopping-list questions policy, and this feels like a shopping-list. It'...
Paul White's user avatar
  • 83.7k
21 votes
Accepted

Is the comment-only answer acceptable?

No Questions that are trivial enough to be answered in this way are too simple for dba.se and should be closed. If it does warrant a full answer, posting the answer as a comment makes the solution ...
10 votes

Do we accept database comparison questions or are they offtopic?

I don't think "this vs that" is a good fit for anything that attempts to be canonical. Each DBMS will change over time, and as such, the answers will vary substantially over time. These types of ...
Hannah Vernon's user avatar
  • 70k
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 ...
6 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 ...
6 votes
Accepted

Is there a canonical list of Magic Links?

Yes This is the official dba.se guidance for canonical links - although it is not guaranteed to be up-to-date (and currently it is slightly out-of-date). See the comments below this post for a ...
4 votes

How do I include tables with Ascii art lines in my answer?

PostgreSQL PostgreSQL's official client, psql, makes this task super easy. It's a command line client. Further formatting options are available, Formatting \a toggle between ...
Evan Carroll's user avatar
  • 62.7k
3 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