Skip to main content
Database Administrators

Good Question

 Good Question
Question score of 25 or more. This badge can be awarded multiple times.
Awarded 1042 times.
How to select specific rows if a column exists or all rows if a column doesn't
Awarded Mar 11 at 17:17
How do I query the running pg_hba configuration?
Awarded Jan 23 at 17:48
Postgres: How to insert row with autoincrement id
Awarded Jan 22 at 5:46
Postgres suggests "Truncate table ... at the same time"
Awarded Jan 17 at 15:47
When does SQL Server warn about an Excessive Memory Grant?
Awarded Jan 16 at 16:01
Concurrent transactions result in race condition with unique constraint on insert
Awarded Jan 2 at 18:02
Postgresql doesn't accept replication connection
Awarded Dec 17, 2024 at 20:41
STRING_SPLIT with order not working on SQL Server 2022
Awarded Dec 6, 2024 at 20:10
What permissions are necessary for truncating a table?
Awarded Nov 6, 2024 at 19:47
Is there a common pattern for storing many boolean flags other than adding a ton of columns?
Awarded Oct 31, 2024 at 10:47
How do I decompose ctid into page and row numbers?
Awarded Oct 19, 2024 at 22:04
Postgres Listen/Notify As Message Queue
Awarded Sep 22, 2024 at 16:33
CREATE DATABASE vs. CREATE ANY DATABASE permissions
Awarded Sep 20, 2024 at 15:27
PostgreSQL: Immutable, Volatile, Stable
Awarded Sep 5, 2024 at 13:51
MySQL FOREIGN KEY constraint is incorrectly formed
Awarded Aug 15, 2024 at 16:07
How to catch and handle only specific Oracle exceptions?
Awarded Jul 25, 2024 at 15:19
Grant access to all tables of a database
Awarded Jul 24, 2024 at 13:33
Collation version mismatch
Awarded Jul 11, 2024 at 18:41
What to set innodb_buffer_pool and why..?
Awarded Jul 3, 2024 at 10:55
Making sense of INNODB buffer pool stats
Awarded Jun 20, 2024 at 9:16
What's the minimum privilege needed to alter a foreign key constraint?
Awarded Jun 20, 2024 at 9:11
Can I change table structure in a transaction and then roll it back if there is an error?
Awarded Jun 11, 2024 at 10:57
MySQL - How to check for a value in all columns
Awarded Jun 10, 2024 at 17:56
MySQL: Return JSON from a standard SQL Query
Awarded Jun 6, 2024 at 19:43
Easy way to check connectivity to SQL Server from client
Awarded May 30, 2024 at 20:51
Using a CREATE TABLE AS SELECT how do I specify a WITH condition (CTE)?
Awarded May 28, 2024 at 16:55
Postgres JOIN conditions vs WHERE conditions
Awarded May 15, 2024 at 19:16
how to update a property value of a jsonb field?
Awarded May 9, 2024 at 16:17
How to use transactions with SQL Server DDL?
Awarded Apr 30, 2024 at 13:41
Get query plan for SQL statement nested in a PL/pgSQL function
Awarded Apr 29, 2024 at 12:15
Should I use the PostgreSQL bit string?
Awarded Apr 29, 2024 at 9:18
Find all the queries executed recently on a database
Awarded Apr 24, 2024 at 18:17
What does [FROM x, y] mean in Postgres?
Awarded Apr 22, 2024 at 11:50
Change existing column in PG to auto-incremental primary key
Awarded Apr 17, 2024 at 11:41
SQL Server not starting at Windows startup but starts manually
Awarded Mar 27, 2024 at 0:09
What is the data type of the ‘ctid’ system column in Postgres?
Awarded Mar 16, 2024 at 13:06
Try catch equivalent in Postgres
Awarded Mar 15, 2024 at 12:06
Tracking stored procedure usage
Awarded Mar 9, 2024 at 15:17
Can two sessions create #temp tables with the same name?
Awarded Mar 6, 2024 at 16:52
Are junction tables a good practice?
Awarded Feb 25, 2024 at 22:18
Not using foreign key constraints in real practice. Is it OK? [duplicate]
Awarded Feb 19, 2024 at 18:26
How to reinitialise /var/lib/mysql files?
Awarded Feb 18, 2024 at 22:48
How to examine PostgreSQL server's SSL certificate?
Awarded Feb 14, 2024 at 22:34
How to promote an existing index to primary key in PostgreSQL
Awarded Feb 11, 2024 at 5:12
Detect when a CREATE INDEX CONCURRENTLY is finished in PostgreSQL
Awarded Jan 24, 2024 at 9:57
How to get notices to the output stream?
Awarded Jan 16, 2024 at 11:21
What is the data type 'name' in PostgreSQL
Awarded Dec 15, 2023 at 12:16
PostgreSQL alternative to SQL Server’s `try_cast` function
Awarded Dec 8, 2023 at 10:11
Query for all the Postgres configuration parameters‘ current values?
Awarded Nov 29, 2023 at 22:32
Multiple on conflict targets
Awarded Nov 23, 2023 at 13:07
Why does NOT IN with a set containing NULL always return FALSE/NULL?
Awarded Nov 22, 2023 at 4:55
SQLCMD command is not able to insert accents
Awarded Nov 6, 2023 at 0:42
SQL Server Management Studio 2012: How to have folders in the SSMS project?
Awarded Nov 5, 2023 at 13:01
How to get particular object from jsonb array in PostgreSQL?
Awarded Oct 19, 2023 at 12:26
Is there a simple way in PL/pgSQL to check if a query returned no result?
Awarded Oct 11, 2023 at 7:42
How to model inheritance of two tables MySQL
Awarded Sep 28, 2023 at 21:33
Multiple databases in same AWS RDS PostgreSQL instance
Awarded Sep 24, 2023 at 23:08
Slow index scans in large table
Awarded Sep 20, 2023 at 9:56
How to exclude NULL values inside CONCAT MySQL?
Awarded Sep 20, 2023 at 6:56
Find objects linked to a PostgreSQL role
Awarded Sep 14, 2023 at 18:35
1
2 3 4 5
…
18