Skip to main content
Database Administrators

Good Question

 Good Question
Question score of 25 or more. This badge can be awarded multiple times.
Awarded 1058 times.
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
How do I best measure the query performance?
Awarded Sep 11, 2023 at 5:35
Suppressing the SSMS prompt to save changes
Awarded Sep 7, 2023 at 17:36
Delete all data in Postgres database
Awarded Aug 30, 2023 at 13:48
Index vs. partition
Awarded Aug 28, 2023 at 10:41
How do I specify that a column should be auto-incremented in pgAdmin?
Awarded Aug 26, 2023 at 17:11
How do I split a long PL/pgSQL line of code over multiple lines?
Awarded Aug 15, 2023 at 9:31
Grant permissions to run a SQL Server job
Awarded Aug 14, 2023 at 10:51
Is there a tool to check if my database is normalized to the third normal form?
Awarded Aug 3, 2023 at 3:11
SQL-Server: Why do we use FILE = 1 in scripts for restoring a database
Awarded Jul 25, 2023 at 12:16
mysql to mariadb: unknown collation utf8mb4_0900_ai_ci
Awarded Jul 21, 2023 at 14:37
Why are constraints applied in the database rather than the code?
Awarded Jul 11, 2023 at 21:16
How do I declare and use variables in Oracle?
Awarded Jul 11, 2023 at 19:03
Get a fixed value on a select
Awarded Jul 6, 2023 at 12:58
Index not used with = ANY() but used with IN
Awarded Jun 27, 2023 at 15:16
Easiest way to duplicate rows
Awarded Jun 24, 2023 at 19:06
Index performance for CHAR vs VARCHAR (Postgres)
Awarded Jun 8, 2023 at 12:41
SQL server 2012 restore wizard freezes
Awarded May 26, 2023 at 10:20
Is the optimisation fence behaviour of a CTE (WITH query) specified in the SQL:2008 standard? If so, where?
Awarded May 22, 2023 at 8:20
Compare two similar Postgres databases for differences [closed]
Awarded May 20, 2023 at 13:43
How to optimization database for heavy I/O from updates (software and hardware)
Awarded May 18, 2023 at 19:02
How to select multiple columns but only group by one?
Awarded May 16, 2023 at 12:56
What are the arguments in favor of using ELT process over ETL?
Awarded May 15, 2023 at 19:22
Best way to design a database and table to keep records of changes?
Awarded May 10, 2023 at 17:51
Track all modifications to a PostgreSQL table
Awarded May 8, 2023 at 6:52
CREATE TABLE AS vs SELECT INTO
Awarded May 2, 2023 at 0:38
What exactly does "No Join Predicate" mean in SQL Server?
Awarded Apr 25, 2023 at 16:27
Transactions within a Transaction
Awarded Apr 22, 2023 at 14:28
Composite indexes: Most selective column first?
Awarded Apr 20, 2023 at 14:06
SQL Server Join/where processing order
Awarded Apr 5, 2023 at 13:34
What is the overhead for varchar(n)?
Awarded Mar 31, 2023 at 13:47
Multiple primary keys in PostgreSQL [closed]
Awarded Mar 22, 2023 at 19:49
Understanding time format of the EXPLAIN command - Postgres
Awarded Mar 1, 2023 at 17:31
Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
Awarded Feb 26, 2023 at 18:26
How to atomically replace table data in PostgreSQL
Awarded Feb 23, 2023 at 22:55
Unquoting JSON strings; print JSON strings without quotes
Awarded Feb 16, 2023 at 17:12
Convert Postgres TIMESTAMP to TIMESTAMPTZ
Awarded Feb 12, 2023 at 11:07
Should I use UUID as well as ID
Awarded Feb 8, 2023 at 17:17
Is there a psql equivalent of bash's reverse-search-history?
Awarded Feb 2, 2023 at 18:20
How can I get a unique array in PostgreSQL?
Awarded Feb 1, 2023 at 20:27
Difference between fetched and returned tuples in postgresql
Awarded Jan 31, 2023 at 18:11
Consistency in ACID and CAP theorem, are they the same?
Awarded Jan 29, 2023 at 1:36
Finding the last time a table was updated
Awarded Jan 21, 2023 at 7:45
PostgreSQL - insert/update violates foreign key constraints
Awarded Jan 19, 2023 at 22:26
Insert results from a stored procedure into a table variable
Awarded Jan 18, 2023 at 4:28
1
2
3 4 5
…
18