Skip to main content
Database Administrators

Good Question

 Good Question
Question score of 25 or more. This badge can be awarded multiple times.
Awarded 1035 times.
STRING_SPLIT with order not working on SQL Server 2022
Awarded Dec 6 at 20:10
What permissions are necessary for truncating a table?
Awarded Nov 6 at 19:47
Is there a common pattern for storing many boolean flags other than adding a ton of columns?
Awarded Oct 31 at 10:47
How do I decompose ctid into page and row numbers?
Awarded Oct 19 at 22:04
Postgres Listen/Notify As Message Queue
Awarded Sep 22 at 16:33
CREATE DATABASE vs. CREATE ANY DATABASE permissions
Awarded Sep 20 at 15:27
PostgreSQL: Immutable, Volatile, Stable
Awarded Sep 5 at 13:51
MySQL FOREIGN KEY constraint is incorrectly formed
Awarded Aug 15 at 16:07
How to catch and handle only specific Oracle exceptions?
Awarded Jul 25 at 15:19
Grant access to all tables of a database
Awarded Jul 24 at 13:33
Collation version mismatch
Awarded Jul 11 at 18:41
What to set innodb_buffer_pool and why..?
Awarded Jul 3 at 10:55
Making sense of INNODB buffer pool stats
Awarded Jun 20 at 9:16
What's the minimum privilege needed to alter a foreign key constraint?
Awarded Jun 20 at 9:11
Can I change table structure in a transaction and then roll it back if there is an error?
Awarded Jun 11 at 10:57
MySQL - How to check for a value in all columns
Awarded Jun 10 at 17:56
MySQL: Return JSON from a standard SQL Query
Awarded Jun 6 at 19:43
Easy way to check connectivity to SQL Server from client
Awarded May 30 at 20:51
Using a CREATE TABLE AS SELECT how do I specify a WITH condition (CTE)?
Awarded May 28 at 16:55
Postgres JOIN conditions vs WHERE conditions
Awarded May 15 at 19:16
how to update a property value of a jsonb field?
Awarded May 9 at 16:17
How to use transactions with SQL Server DDL?
Awarded Apr 30 at 13:41
Get query plan for SQL statement nested in a PL/pgSQL function
Awarded Apr 29 at 12:15
Should I use the PostgreSQL bit string?
Awarded Apr 29 at 9:18
Find all the queries executed recently on a database
Awarded Apr 24 at 18:17
What does [FROM x, y] mean in Postgres?
Awarded Apr 22 at 11:50
Change existing column in PG to auto-incremental primary key
Awarded Apr 17 at 11:41
SQL Server not starting at Windows startup but starts manually
Awarded Mar 27 at 0:09
What is the data type of the ‘ctid’ system column in Postgres?
Awarded Mar 16 at 13:06
Try catch equivalent in Postgres
Awarded Mar 15 at 12:06
Tracking stored procedure usage
Awarded Mar 9 at 15:17
Can two sessions create #temp tables with the same name?
Awarded Mar 6 at 16:52
Are junction tables a good practice?
Awarded Feb 25 at 22:18
Not using foreign key constraints in real practice. Is it OK? [duplicate]
Awarded Feb 19 at 18:26
How to reinitialise /var/lib/mysql files?
Awarded Feb 18 at 22:48
How to examine PostgreSQL server's SSL certificate?
Awarded Feb 14 at 22:34
How to promote an existing index to primary key in PostgreSQL
Awarded Feb 11 at 5:12
Detect when a CREATE INDEX CONCURRENTLY is finished in PostgreSQL
Awarded Jan 24 at 9:57
How to get notices to the output stream?
Awarded Jan 16 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
1
2 3 4 5
…
18