Database Administrators

Student

 Student
First question with score of 1 or more.
Awarded 36952 times.
MySQL undo logs not truncating
Awarded 2 hours ago
MySQL - Restore 1TB database using myloader
Awarded 6 hours ago
MySQL 5.7.42, Gradual memory growth over time, memory leak?
Awarded 2 days ago
MySQL: display only the dates of the days that fall on a Sat. or Sun. between two given dates?
Awarded 2 days ago
Azure SQL Design Recommendation
Awarded May 27 at 11:50
Trap exception in PostgreSQL script
Awarded May 27 at 8:20
How to update a foreign key with random values from the referenced table?
Awarded May 26 at 15:56
RDBMS performance on updating an index key(non primary)
Awarded May 26 at 9:55
How to release SSAS memory without forcing restart
Awarded May 26 at 9:31
SQL Server BACKUP FULL by variables
Awarded May 26 at 7:45
PDB Oracle DB ORA-40365
Awarded May 25 at 12:41
Tuning MYSQL 8.0.32 for my server
Awarded May 25 at 9:30
Best way to store millions of measurements with hundreds of columns
Awarded May 25 at 9:12
How to structure postgreSQL db for multiple different variations of a form
Awarded May 25 at 8:57
sql server - How to prevent backup db file to load on any SQL server instance
Awarded May 25 at 8:41
Super slow index scan from IN subquery (generated by third party software). Tuning postgres or rewriting query?
Awarded May 25 at 7:26
Why does Postgres sometimes choose to use parallel workers, and other times not?
Awarded May 24 at 19:34
Huge /mysql/ folder size - about 289gb
Awarded May 24 at 15:08
Why does batch referencing non existing column fails outright?
Awarded May 24 at 10:57
(post deleted or otherwise unavailable)
Awarded May 23 at 20:42
Maximum number subscribers node in PostgreSQL logical replication?
Awarded May 23 at 17:50
SQL server chooses hash match over merge join but the input fields to join should be sorted
Awarded May 23 at 16:50
why sys.dm_db_persisted_sku_features shows results that compatible with Standard edition?
Awarded May 23 at 10:05
The size of my table is not growing
Awarded May 22 at 22:16
to copy column from one table to another in psql
Awarded May 22 at 20:21
MariaDB FATAL ERROR: Upgrade Failed
Awarded May 22 at 19:06
using "\dp table_name" in "psql" throws "operator is not unique"
Awarded May 22 at 12:20
MySQL ORDER BY Indexes When ORDER BY May be Unknown
Awarded May 22 at 7:47
OPEN SYMMETRIC KEY from AKV takes too long randomly
Awarded May 22 at 7:03
Full text search can not find incomplete words
Awarded May 21 at 3:42
Function returns one row, but the query it wraps returns many
Awarded May 20 at 23:55
Lost connection to the database during COMMIT query: did the transaction succeed or not?
Awarded May 20 at 17:17
AWS RDS Postgres configuration for database disk size >1TB and almost 1B records?
Awarded May 19 at 7:25
How to convert json array to json object in PostgreSQL?
Awarded May 19 at 0:40
PostgreSQL RDS: Slower than expected performance when large table / index is not in cache
Awarded May 18 at 19:16
SQL Server on LInux - OpenRowSet function only has access to files in /var/opt/mssql directory?
Awarded May 18 at 17:22
When to use MySQL handler syntax?
Awarded May 18 at 11:42
Nested push in Mongoose
Awarded May 18 at 8:11
How do I install an older version on Debian systems?
Awarded May 17 at 23:26
I want to find the max number of characters of all varchar and nvarchar columns in DB
Awarded May 17 at 16:26
Are there any databases that properly support sum types/tagged unions?
Awarded May 17 at 13:17
Postgres query planning on a per-statement basis
Awarded May 17 at 11:07
Handling server upgrades through packaging system (apt) when running group replication
Awarded May 16 at 21:42
Connecting to cluster with cqlsh returns "Unable to connect to any servers"
Awarded May 16 at 12:28
Database design/schema for position hierarchy approval process for leave management
Awarded May 16 at 6:15
What strategy should I use for my gigant MYSQL Tables?
Awarded May 15 at 19:56
How to write (postgres) RLS-policies for related/nested tables?
Awarded May 15 at 18:48
I have data with column names as dates and I need to unpivot this columns into Dates column and values. How can i get this in oracle SQL developer
Awarded May 15 at 13:12
MySQL read replica using more storage and has more rows than master DB
Awarded May 15 at 7:40
Mysql 8, how to fix replication when master IP changes?
Awarded May 15 at 3:26
PostGres with 62 GB of table gobbling up over 500 GB on disk? SOLVED
Awarded May 14 at 1:16
Aggragate values over time in temporal table
Awarded May 13 at 12:34
Moving Innodb database from Server A to server b
Awarded May 13 at 12:34
Which SQL Server component is in charge with checking cached execution plans for a given query?
Awarded May 12 at 19:27
“ORA-03146: invalid buffer length for TTC field” after upgrade from Oracle 12 to 19c
Awarded May 12 at 13:17
How can I use pg_dump to export a single table to CSV that can then be imported by Oracle SQL Loader?
Awarded May 11 at 18:52
How to run SELECT only if condition is met
Awarded May 11 at 16:02
Slow Cross Apply Query Needs Optimization
Awarded May 11 at 13:56
How do distributed databases follow unique constraints?
Awarded May 11 at 13:48
How do I get the total number of SSTables with nodetool?
Awarded May 11 at 11:41
1
2 3 4 5
…
616

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.