Database Administrators

Good Question

 Good Question
Question score of 25 or more. This badge can be awarded multiple times.
Awarded 955 times.
Understanding time format of the EXPLAIN command - Postgres
Awarded Mar 1 at 17:31
Table mysql/innodb_index_stats has length mismatch in the column name table_name. Please run mysql_upgrade
Awarded Feb 26 at 18:26
How to atomically replace table data in PostgreSQL
Awarded Feb 23 at 22:55
Unquoting JSON strings; print JSON strings without quotes
Awarded Feb 16 at 17:12
Convert Postgres TIMESTAMP to TIMESTAMPTZ
Awarded Feb 12 at 11:07
Should I use UUID as well as ID
Awarded Feb 8 at 17:17
Is there a psql equivalent of bash's reverse-search-history?
Awarded Feb 2 at 18:20
How can I get a unique array in PostgreSQL?
Awarded Feb 1 at 20:27
Difference between fetched and returned tuples in postgresql
Awarded Jan 31 at 18:11
Consistency in ACID and CAP theorem, are they the same?
Awarded Jan 29 at 1:36
Finding the last time a table was updated
Awarded Jan 21 at 7:45
PostgreSQL - insert/update violates foreign key constraints
Awarded Jan 19 at 22:26
Insert results from a stored procedure into a table variable
Awarded Jan 18 at 4:28
FlushCache messages appearing in log at specific times
Awarded Jan 16 at 22:08
Check progress of alter index reorganize / rebuild
Awarded Jan 6 at 14:19
Operator used tempdb to spill data during execution with spill level 2
Awarded Jan 6 at 10:57
Benefits of using WITH TABLOCK on an INSERT
Awarded Jan 6 at 10:57
How do I restore a plain text postgres .backup file
Awarded Dec 27, 2022 at 9:18
SQL server DB status runnable, sleeping, suspended, running and background meanings
Awarded Dec 22, 2022 at 8:40
How do I access Postgres when I get an error about "/var/run/postgresql/.s.PGSQL.5432"?
Awarded Dec 22, 2022 at 8:40
Why does a simple loop result in ASYNC_NETWORK_IO waits?
Awarded Dec 22, 2022 at 8:40
Composite Primary Key in multi-tenant SQL Server database
Awarded Dec 22, 2022 at 8:40
Ignore accents in 'where' clause
Awarded Dec 22, 2022 at 8:40
How to generate a sequence in mysql
Awarded Dec 22, 2022 at 8:40
Mongo Create a user as admin for any database raise an error
Awarded Dec 22, 2022 at 8:40
Rolling sum / count / average over date interval
Awarded Dec 22, 2022 at 8:40
How can I reset a mysql table auto-increment to 1 in phpMyAdmin?
Awarded Dec 22, 2022 at 8:40
Do empty columns take up space in a table?
Awarded Dec 22, 2022 at 8:40
How do I shrink the innodb file ibdata1 without dumping all databases?
Awarded Dec 22, 2022 at 8:40
"Could not find stored procedure' even though the stored procedure have been created in MS SQL Server Management Studio
Awarded Dec 22, 2022 at 8:40
How does this syntax work? {fn CurDate()} or {fn Now()} etc
Awarded Dec 22, 2022 at 8:40
How badly do SQL Compilations impact the performance of SQL Server?
Awarded Dec 22, 2022 at 8:40
Should a MySQL replication slave be set to read only?
Awarded Dec 22, 2022 at 8:40
Could a null column be part of a primary key?
Awarded Dec 22, 2022 at 8:40
How to preserve the original order of elements in an unnested array?
Awarded Dec 22, 2022 at 8:40
How to ORDER BY typical software release versions like X.Y.Z?
Awarded Dec 22, 2022 at 8:40
How can I add a rowversion column to a large table with minimal downtime
Awarded Dec 22, 2022 at 8:40
Limit results to the first 2 ranking rows
Awarded Dec 22, 2022 at 8:40
Should I stop transaction log backups during a full backup?
Awarded Dec 22, 2022 at 8:40
Need to understand parallel query execution error
Awarded Dec 22, 2022 at 8:40
What is more efficient, a where clause or a join with million plus row tables?
Awarded Dec 22, 2022 at 8:40
How do I install pgcrypto in PostgreSQL 8.4?
Awarded Dec 22, 2022 at 8:40
Get all partition names for a table
Awarded Dec 20, 2022 at 2:19
How do you view PostgreSQL messages (such as RAISE NOTICE) in DBeaver?
Awarded Dec 11, 2022 at 4:31
Why does PostgreSQL allow querying for array[0] even though it uses 1-based arrays?
Awarded Dec 8, 2022 at 17:08
Pros/Cons of using multiple databases vs using a single database
Awarded Dec 8, 2022 at 12:41
How to best use connection pooling in SQLAlchemy for PgBouncer transaction-level pooling?
Awarded Dec 2, 2022 at 20:57
Backup/Restore Users/Passwords/Privileges
Awarded Nov 27, 2022 at 1:11
Is data retrieved from SQL Server compressed for transmission?
Awarded Nov 23, 2022 at 15:36
Automatic aging-out (deletion) of old records in Postgres
Awarded Nov 14, 2022 at 14:35
How do I resolve this error, "ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'"?
Awarded Oct 26, 2022 at 12:58
How to have a one-to-many relationship with a privileged child?
Awarded Oct 15, 2022 at 19:40
Why Do My Nonclustered Indexes Use More Space When I Delete Rows?
Awarded Oct 13, 2022 at 13:27
Why did MySQL remove the query cache feature after version 8.0?
Awarded Oct 12, 2022 at 8:50
Index performance for CHAR vs VARCHAR (Postgres)
Awarded Oct 10, 2022 at 13:55
What is the purpose of a Row_GUID column?
Awarded Oct 8, 2022 at 4:40
PostgreSQL: Creation date of a table
Awarded Oct 3, 2022 at 14:34
How to insert in a table with only an IDENTITY column?
Awarded Sep 30, 2022 at 15:51
How is LIKE implemented?
Awarded Sep 25, 2022 at 20:01
Counting rows from a subquery
Awarded Sep 24, 2022 at 23:45
1
2 3 4 5
…
16

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.