Database Administrators

Guru

 Guru
Accepted answer and score of 40 or more. This badge can be awarded multiple times.
Awarded 398 times.
Source several files at once with psql
Awarded Dec 1 at 7:01
How to remove string quotes in MySQL 5.7 for function JSON_EXTRACT?
Awarded Sep 19 at 6:06
DELETE rows which are not referenced in other table
Awarded Jun 29 at 11:17
The login already has an account under a different user name
Awarded Jun 29 at 4:26
When should you denormalize?
Awarded Jun 15 at 20:04
How to store one-byte integer in PostgreSQL?
Awarded May 24 at 6:33
SQL Server Error 8632 due to over 100,000 entries in WHERE clause
Awarded May 10 at 8:20
Why is the default page size for databases so small?
Awarded Apr 29 at 17:16
In PostgreSQL, is there a type-safe first() aggregate function?
Awarded Apr 20 at 18:57
Increasing work_mem and shared_buffers on Postgres 9.2 significantly slows down queries
Awarded Apr 13 at 2:51
Multiple primary keys in PostgreSQL
Awarded Mar 27 at 16:20
Easiest way to duplicate rows
Awarded Mar 5 at 9:46
Convert Postgres TIMESTAMP to TIMESTAMPTZ
Awarded Mar 1 at 19:02
What happens in PostgreSQL checkpoint?
Awarded Feb 27 at 15:46
Can I add a unique constraint that ignores existing violations?
Awarded Feb 22 at 10:27
How to determine if there are [idle connections with] uncommitted transactions in PostgreSQL?
Awarded Feb 17 at 0:10
MySQL - Difference between using count(*) and information_schema.tables for counting rows
Awarded Feb 13 at 23:50
How do I know what indexes to create for a table?
Awarded Jan 19 at 13:56
Get all partition names for a table
Awarded Jan 18 at 15:47
Counting rows from a subquery
Awarded Jan 2 at 14:16
How to cast an integer to a boolean in a MySQL SELECT clause?
Awarded Dec 19, 2022 at 13:35
Can I provide a default for a left outer join?
Awarded Dec 5, 2022 at 19:18
restoring Postgres database: pg_restore -vs- just using psql
Awarded Nov 10, 2022 at 8:57
Not using foreign key constraints in real practice. Is it OK?
Awarded Oct 19, 2022 at 8:04
What is mysql_native_password?
Awarded Sep 26, 2022 at 7:35
How to set Postgresql database to see date as "MDY" permanently
Awarded Sep 16, 2022 at 11:15
What is the meaning of n_live_tup and n_dead_tup in pg_stat_user_tables
Awarded Sep 12, 2022 at 10:27
Why does ORDER BY not belong in a View?
Awarded Sep 9, 2022 at 14:03
Is there a way to show the creation statement for an index in PostgreSQL
Awarded Sep 7, 2022 at 20:47
SLEEP_TASK Wait Type in SQL Server - What does it indicate?
Awarded Aug 17, 2022 at 11:10
Using source columns in OUTPUT INTO clause of an INSERT statement (SQL Server)
Awarded Aug 15, 2022 at 17:07
How to wrap long lines when SELECTing SQL text columns?
Awarded Aug 8, 2022 at 14:43
Permission denied for relation <table>
Awarded Jul 20, 2022 at 23:42
Using column alias in a WHERE clause doesn't work
Awarded Jul 6, 2022 at 23:11
How to run psql on Mac OS X?
Awarded Jul 6, 2022 at 9:47
Eliminate Key Lookup (Clustered) operator that slows down performance
Awarded Jun 29, 2022 at 21:15
Error Code 1117 Too many columns; MySQL column-limit on table
Awarded Jun 28, 2022 at 9:49
Case with multiple conditions
Awarded Jun 14, 2022 at 12:35
Reference column alias in same SELECT list
Awarded May 6, 2022 at 6:55
Custom unique constraint, only enforced if one column has a specific value
Awarded Apr 26, 2022 at 9:19
How to get all roles that a user is a member of (including inherited roles)?
Awarded Apr 22, 2022 at 10:36
Set names to attributes when creating JSON with row_to_json
Awarded Apr 13, 2022 at 21:50
PostgreSQL EXCLUDE USING error: Data type integer has no default operator class
Awarded Mar 7, 2022 at 15:57
How do you view PostgreSQL messages (such as RAISE NOTICE) in DBeaver?
Awarded Feb 8, 2022 at 14:53
How to grant permissions on a table-valued function
Awarded Jan 12, 2022 at 20:18
Retrieving all PK and FK
Awarded Nov 19, 2021 at 18:55
How to change the schema of stored procedure without recreating it
Awarded Nov 16, 2021 at 8:12
Benefits of using backtick (`) in MySQL queries?
Awarded Nov 11, 2021 at 17:36
How can I force SQL Server Management Studio to update the IntelliSense cache?
Awarded Nov 9, 2021 at 18:55
Check if a user exists in a SQL Server database
Awarded Nov 8, 2021 at 19:27
disable constraints before using pg_restore.exe
Awarded Oct 31, 2021 at 18:17
Is table aliasing a bad practice?
Awarded Oct 27, 2021 at 9:32
List Jobs, Schedules, and Next Scheduled Run Datetimes
Awarded Oct 8, 2021 at 18:51
mysql Lock wait timeout exceeded; try restarting transaction
Awarded Oct 1, 2021 at 9:35
What is the impact of LC_CTYPE on a PostgreSQL database?
Awarded Sep 10, 2021 at 7:50
How to SELECT from SHOW TABLE STATUS results
Awarded Aug 30, 2021 at 14:40
Troubleshooting high CPU usage from postgres and postmaster services?
Awarded Aug 24, 2021 at 16:11
mysqldump with INSERT ... ON DUPLICATE
Awarded Jul 27, 2021 at 18:56
Optimising plans with XML readers
Awarded Jul 27, 2021 at 10:57
MySQL Count rows from another table for each record in table
Awarded Jul 23, 2021 at 9:03
1
2 3 4 5
…
7

Your privacy

By clicking “Accept all cookies”, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy.