Database Administrators
Sponsored by
Sponsored logo

Teacher

 Teacher
Answer a question with score of 1 or more.
Awarded 14200 times.
How to run pg_dump so that it doesn't slow down other connections?
Awarded 1 hour ago
SQL AES_256 Encryption and Decryption
Awarded 4 hours ago
Count how many variables equal a target value
Awarded 2 days ago
1286 - Unknown storage engine 'InnoDB'
Awarded 2 days ago
Can ransomware embed itself in to a SQL backup file?
Awarded 2 days ago
ProxySQL user not connecting - XtraDB
Awarded 2 days ago
MySQL: How to create Column if not exists?
Awarded May 12 at 12:57
Is it a good or bad idea to use "ON UPDATE CASCADE ON DELETE CASCADE" for foreign keys? Why does this mechanism exist at all?
Awarded May 11 at 18:36
Forcing a sequential scan over the index scan
Awarded May 11 at 12:35
MySQL any way to import a huge (32 GB) sql dump faster?
Awarded May 11 at 11:56
How to resolve "InnoDB data dictionary has tablespace id N"
Awarded May 10 at 18:51
How to check whether TimescaleDB view is defined `WITH DATA` or `WITH NO DATA`?
Awarded May 10 at 15:30
Replication external Master to RDS Slave: Connection issue
Awarded May 9 at 15:50
Database archiving strategy
Awarded May 9 at 12:11
(post deleted or otherwise unavailable)
Awarded May 8 at 19:38
PostgreSQL query for parent - child relations
Awarded May 7 at 11:00
Deleting duplicate value in View from the Base table
Awarded May 6 at 17:51
Foreign key location
Awarded May 6 at 15:17
how to GRANT EXECUTE on MySQL
Awarded May 6 at 13:17
Update existing rows with squence number/char or any unique data
Awarded May 4 at 2:36
Is there a limit to how many credentials SSMS can remember?
Awarded May 3 at 19:51
How to retain same FLOAT value after converting it to a VARCHAR in Azure Synapse
Awarded May 3 at 16:35
Extension "plpythonu" is not supported by Amazon RDS
Awarded May 3 at 7:56
SQL SERVER FileTable/FILESTREAM share suddenly becomes unavailable
Awarded Apr 29 at 16:47
Should order of column in where clause be same as the index order?
Awarded Apr 29 at 8:01
SQL Server Extended Events odd behavior trying to capture statements coming from SAS
Awarded Apr 28 at 17:03
I need to run VACUUM FULL with no available disk space
Awarded Apr 27 at 10:35
Replication jobs are not getting created after failover
Awarded Apr 25 at 18:30
How to insert values into a table from a select query in PostgreSQL?
Awarded Apr 24 at 15:33
ERROR: could not open extension control file "/usr/share/postgresql/13/extension/postgis.control": No such file or directory
Awarded Apr 24 at 12:21
Export Postgres sequences only
Awarded Apr 23 at 21:35
Problem with Czech collation Czech_CI_AI in MS SQL Server 2008 R2
Awarded Apr 21 at 7:31
how to let dbeaver to highlight sql error for easier development process
Awarded Apr 21 at 3:26
In PostgreSQL URL I can't use a password containing special characters
Awarded Apr 20 at 6:58
How can I prevent mysqldump from prepending the database name in CREATE VIEW?
Awarded Apr 19 at 11:41
Cannot remove unused filegroups
Awarded Apr 19 at 10:11
db<>fiddle (Oracle): Query works in 18c, but not 21c
Awarded Apr 18 at 15:19
Out of disk space while dropping columns from a mysql table
Awarded Apr 16 at 3:42
SQL Azure simple update fails (or takes many minutes) not due to blocking
Awarded Apr 15 at 12:45
oracle - Change host to 0.0.0.0 in listener
Awarded Apr 14 at 14:11
ALTER causes "Time-out occurred while waiting for buffer latch type 2"
Awarded Apr 14 at 9:34
why mysql only works for root user?
Awarded Apr 14 at 6:10
Execute system commands in postgresql
Awarded Apr 14 at 5:49
How to write select statment that get data based on partid from last date to current date with filling gapes?
Awarded Apr 14 at 2:34
Is there any purpose of Ola Hallengren's SQL Server Index and Statistics Maintenance scripts on sql server running on SAN storage?
Awarded Apr 13 at 14:48
MongoDB aggregation. Trying to use switch in map
Awarded Apr 13 at 11:56
Postgresql partitioning queries benefits
Awarded Apr 13 at 6:47
MongoDB -- Failed global initialization: Failed to open "var/log/mongodb/mongod.log"
Awarded Apr 13 at 0:55
Does Postgres read through entire WAL when starting replication from later point?
Awarded Apr 10 at 7:27
EXPLAIN output suggests that my index is not being used
Awarded Apr 8 at 10:16
How to migrate the permissions of logins - for example - grant/remove/deny permissions on system objects and server instance?
Awarded Apr 8 at 5:27
Get explain plan for query with inline function
Awarded Apr 8 at 2:31
PostgreSQL naming conventions
Awarded Apr 5 at 21:57
MySQL Workbench query tabs
Awarded Apr 5 at 11:25
pt-online-schema-change's triggers fail with "DELETE command denied" on insert
Awarded Apr 4 at 22:33
TDE Backups Won't Compress with NOINIT
Awarded Apr 4 at 11:26
could not load library "/usr/pgsql-10/lib/postgis-2.5.so": /usr/pgsql-10/lib/postgis-2.5.so: undefined symbol: GEOSFrechetDistanceDensify
Awarded Apr 3 at 22:11
how to update one column with trigger mysql
Awarded Apr 3 at 20:16
Can SET IDENTITY_INSERT be allowed with less privileges than db_ddladmin?
Awarded Apr 3 at 14:17
PostgreSQL: Generated Columns
Awarded Apr 2 at 23:06
1
2 3 4 5
…
237

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.