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.
Make Postgres database temporarily read-only (for performing volume snapshots)
Awarded Nov 20 at 15:51
When is a Dynamic Port "dynamic"?
Awarded Nov 14 at 8:36
Why can't rows inserted in a CTE be updated in the same statement?
Awarded Oct 22 at 18:26
Why doesn't this query use an index spool?
Awarded Sep 11 at 22:01
Creating a UNIQUE constraint from a JSON object
Awarded Aug 7 at 2:10
Why aren't unsigned integer types available in the top database platforms?
Awarded Aug 4 at 19:12
Percona vs MySQL
Awarded Jul 18 at 21:36
How to check for Non-Ascii Characters
Awarded Jul 9 at 16:07
Deferrable unique index in postgres
Awarded Jul 9 at 6:17
Using DISTINCT in window function with OVER
Awarded Jul 2 at 2:10
How do I download SQL Server 2019 developer edition?
Awarded Jun 26 at 9:06
Decision criteria on when to use a non-dbo schema vs a new Database
Awarded Jun 25 at 22:08
How to add a Default constraint while creating a table? SQL Server
Awarded Jun 25 at 19:53
Choosing the right algorithm in HashBytes function
Awarded Jun 24 at 19:02
Why would a table with a Clustered Columnstore Index have many open rowgroups?
Awarded Jun 24 at 19:02
Do I need separate indexes for each type of query, or will one multi-column index work?
Awarded Jun 24 at 19:02
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
1
2 3 4 5
…
18