Skip to main content
Database Administrators

Popular Question

 Popular Question
Question with 1,000 views. This badge can be awarded multiple times.
Awarded 47608 times.
How to solve "Servlet error" when using database control in Oracle 12c?
Awarded Nov 6 at 18:06
RESTORE VERIFYONLY FROM DISK is failing
Awarded Nov 6 at 16:45
Making production data accessible to developers via masking
Awarded Nov 6 at 16:37
MySQL Replication after a set period of time
Awarded Nov 6 at 14:22
Foreign key violations detected upon UPDATE on another column
Awarded Nov 6 at 14:17
Oracle to SQL Server Conversion help: sys_connect_by_path, listagg, regexp
Awarded Nov 6 at 13:56
Deadlock reading table inside an update trigger
Awarded Nov 6 at 10:08
Can't connect to SQL Server
Awarded Nov 6 at 9:18
DPM transaction log backups of SQL Server partially contained databases
Awarded Nov 6 at 9:07
How to find child and grandchildren tables of a main table by order
Awarded Nov 6 at 7:58
Return a resultset as JSON text—using pretty formatting
Awarded Nov 6 at 7:51
MultiSubnet Failover with RegisterAllProvidersIP 1
Awarded Nov 6 at 2:36
select row number increment on value change compared to previous return result
Awarded Nov 5 at 21:42
How to create xml string for each row of table?
Awarded Nov 5 at 18:26
How to read/write from replicated secondary in case primary went down in SQL Server?
Awarded Nov 5 at 17:43
MSSQL Server 2022 on Linux: sys.* tables very slow for non-db_owner users
Awarded Nov 5 at 15:40
Why query takes ages when I filter by an indexed boolean column?
Awarded Nov 5 at 13:46
converting/adapting time postgres SQL to H2
Awarded Nov 5 at 10:47
Should fields that are set to Not Null also have a constraint refusing empty strings?
Awarded Nov 5 at 9:48
Is it possible to prevent data loss with Postgres WAL archiving?
Awarded Nov 4 at 18:23
Find which databases have a particular service in SQL Server Service Broker
Awarded Nov 4 at 18:23
Do PostgreSQL triggers execute in the same transaction as the original statement?
Awarded Nov 4 at 17:56
MySQL 8 trailing spaces being evaluated in equals comparison
Awarded Nov 4 at 17:08
Filter customers with negative balance across multiple accounts
Awarded Nov 4 at 16:33
How can I get the max value for each column?
Awarded Nov 4 at 16:03
PostgreSQL HA using HAProxy and Patroni
Awarded Nov 4 at 15:14
How to rtrim the slash character (/)?
Awarded Nov 4 at 13:40
What is the limit on the number of transactions waiting for a lock in SQL Server?
Awarded Nov 4 at 12:26
Backup Database in SQL Server
Awarded Nov 4 at 4:19
How to correctly set max_file_size for a file target of an extended event session?
Awarded Nov 3 at 23:50
SOLVED - Mariadb replication Master Slave fail with error code 1595
Awarded Nov 3 at 22:03
Finding all the index corruptions in the entire Postgres DB
Awarded Nov 3 at 20:36
SQL Server Buffer Pool Utilization under VMWare
Awarded Nov 3 at 10:08
How can I update values based on the value from the previous day?
Awarded Nov 3 at 8:36
Fast local backup - Very slow backup via Network
Awarded Nov 3 at 5:09
Data redaction with regex in Oracle
Awarded Nov 1 at 22:56
Confusing error message from Service Broker / Activation procedure
Awarded Nov 1 at 19:56
Query from Postgres to SQL Server
Awarded Nov 1 at 15:33
Insufficient Privileges after creating Pluggable Database
Awarded Nov 1 at 12:08
pg_repack binaries under windows
Awarded Nov 1 at 9:42
Is it possible to override a ReadCommittedSnapshot isolation level with ReadCommitted isolation level for a particular transaction?
Awarded Nov 1 at 5:56
Oracle: Database writers idle until 'Checkpoint not complete' even with multiple redo logs
Awarded Nov 1 at 3:05
Share centralized queries for multiple databases
Awarded Oct 31 at 21:10
How two phases locking ensures serializable?
Awarded Oct 31 at 17:27
Advisable to restart a SQL Server running Windows when disk space is low?
Awarded Oct 31 at 13:56
Error: unable to find network path in Microsoft SQL Server Management Studio
Awarded Oct 31 at 10:31
RAISE NOTICE doesn't work as expected while using within Dynamic SQL block
Awarded Oct 31 at 10:03
Character Set Encoding in a Table
Awarded Oct 31 at 9:06
User Account Mismatch
Awarded Oct 31 at 8:05
Making an Oracle XE instance network wide available
Awarded Oct 31 at 4:16
Could a busy database affect others on the same server? [closed]
Awarded Oct 31 at 1:37
MySQL version of split_to_array or split_to_table?
Awarded Oct 30 at 21:45
SQL Server Always On AG – Is a Passive Secondary Required for Automatic Failover?
Awarded Oct 30 at 19:40
Table-valued Data in Common Table Expression
Awarded Oct 30 at 15:19
Oraagent many SYSRAC processes open
Awarded Oct 30 at 14:55
ORA-12546: TNS:permission denied after restarting the system
Awarded Oct 30 at 13:47
Modify Collation of a column
Awarded Oct 30 at 12:39
How can I group / display same date data in one row?
Awarded Oct 30 at 10:46
Backup a single table
Awarded Oct 30 at 9:49
Estimated rows very wrong when using declared variables
Awarded Oct 30 at 6:26
1
…
3 4
5
6 7
…
794