Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.

Sign up to join this community
Anybody can ask a question
Anybody can answer
The best answers are voted up and rise to the top
Database Administrators

Top Questions

Ask Question
Active Hot Week Month
0 votes
0 answers
3 views

Whether to run integrity check before or after backups (Ola H FAQ)?

variable's user avatar
variable
  • 3,360
0 votes
3 answers
363 views

How to get last inserted rows where a condition is satisfied

Community's user avatar
CommunityBot
  • 1
1 vote
1 answer
2k views

duplicate key error index MongoDB

Community's user avatar
CommunityBot
  • 1
0 votes
0 answers
3 views

Hashes vs key scan in REDIS

ChocolateOverflow's user avatar
ChocolateOverflow
  • 99
0 votes
0 answers
3 views

MySQL is corrupted and not able to start mysql even after innodb_force_recovery=6

Sunny Drall's user avatar
Sunny Drall
  • 101
0 votes
1 answer
434 views

Is it possible to select all columns but one column using SQL syntax?

J.D.'s user avatar
J.D.
  • 34k
0 votes
1 answer
433 views

support of multiple databases on different hosts by pgpool2

Community's user avatar
CommunityBot
  • 1
0 votes
0 answers
19 views

sql server transactional replication high latency

James Z's user avatar
James Z
  • 2,219
1 vote
1 answer
336 views

SQL Server and Windows on the same disk (allocation unit size 64kb-4kb)

Community's user avatar
CommunityBot
  • 1
0 votes
0 answers
13 views

Update parent table, based on one record from children table (one-to-many)

Saeed Neamati's user avatar
Saeed Neamati
  • 1,405
0 votes
1 answer
571 views

Repmgr : It automatically promotes to new master but other standby stopped

Community's user avatar
CommunityBot
  • 1
1 vote
1 answer
8 views

MariaDB 11.0 to 11.1 GA fails with ERROR 1210 (HY000) at line 32: Incorrect arguments to DATA DIRECTORY

user946207's user avatar
user946207
  • 21
4 votes
1 answer
127 views

Configure SSMS intellisense / web browser settings to accept UNC directory path inputs

Glorfindel's user avatar
Glorfindel
  • 2,181
8 votes
1 answer
2k views

Frequent, "random" SQL Server connection timeouts

Glorfindel's user avatar
Glorfindel
  • 2,181
2 votes
2 answers
303 views

Spotlight for SQL Server LockType explanation required

Glorfindel's user avatar
Glorfindel
  • 2,181
0 votes
1 answer
273 views

mysql.gtid_executed table is empty

Community's user avatar
CommunityBot
  • 1
1 vote
1 answer
274 views

Enforce password policy after creating a login

Community's user avatar
CommunityBot
  • 1
0 votes
0 answers
27 views

How to Count calculated work hours in one month for each labors

Ergest Basha's user avatar
Ergest Basha
  • 3,685
1 vote
2 answers
755 views

csv import fails without throwing an error

Community's user avatar
CommunityBot
  • 1
-1 votes
1 answer
1k views

mysql trigger to trigger only if record doesn't exist

Community's user avatar
CommunityBot
  • 1
39 votes
8 answers
78k views

Does SQL Server support GREATEST and LEAST, if not what is the common workaround?

Paul White's user avatar
Paul White♦
  • 82.1k
8 votes
1 answer
1k views

RDS MYSQL instance rebooted and won't load INNODB table

Community's user avatar
CommunityBot
  • 1
0 votes
2 answers
625 views

Query other database's INFORMATION_SCHEMA tables

Community's user avatar
CommunityBot
  • 1
0 votes
0 answers
18 views

mysql group replication, how to relocate replication channel from one master to another

8030_Kanav_Sharma's user avatar
8030_Kanav_Sharma
  • 1
0 votes
1 answer
711 views

How to add/create default partition for a table in mysql

Community's user avatar
CommunityBot
  • 1
1 vote
2 answers
578 views

mySQL Workbench new Connection : There is no disk in drive. Please insert disk in \Device\Harddisk2\DR2

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
4k views

Replications fails with a vague message: "The last step to run was step 3: Detect nonlogged agent shutdown"

Community's user avatar
CommunityBot
  • 1
0 votes
0 answers
34 views

Convert a list-of-IDs column into a junction table

nivomi's user avatar
nivomi
  • 11
1 vote
1 answer
361 views

Loop Block with execution doesn't persist

Community's user avatar
CommunityBot
  • 1
5 votes
1 answer
668 views

Adding a Primary Key to a Large PostgreSQL Table with High Traffic

Erwin Brandstetter's user avatar
Erwin Brandstetter
  • 170k
3 votes
1 answer
387 views

Installing Postgresql parray_gin extension on mac, include not found

Community's user avatar
CommunityBot
  • 1
2 votes
1 answer
285 views

Parameter Sniffing in SQL Server 2022

Mehdi Ghapanvari's user avatar
Mehdi Ghapanvari
  • 1
0 votes
2 answers
446 views

Error 23 on transaction log backup, full backup works fine

Community's user avatar
CommunityBot
  • 1
1 vote
0 answers
9 views

There was a recoverable, provider-specific error, such as an RPC failure. SQL to MySQL linked server no longer working

Yourguide's user avatar
Yourguide
  • 11
0 votes
1 answer
495 views

Using custom port for listener

Community's user avatar
CommunityBot
  • 1
1 vote
0 answers
17 views

Migrating from PostgreSQL to MySQL (data with \r\n)

Ray's user avatar
Ray
  • 113
0 votes
1 answer
429 views

How to re-sync the Mysql DB if some Masters have different database incase of MySQL Group replication?

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
408 views

How to downgrade between General Availability versions of MySQL?

Community's user avatar
CommunityBot
  • 1
4 votes
3 answers
3k views

Why aren't some spid values showing up in sys.dm_exec_requests?

Erik Darling's user avatar
Erik Darling
  • 38.2k
0 votes
1 answer
972 views

ORACLE execute error: ORA-01950: no privileges on tablespace 'PDATA'

Community's user avatar
CommunityBot
  • 1
3 votes
1 answer
753 views

Mongo WriteConflictException in log file

Community's user avatar
CommunityBot
  • 1
2 votes
2 answers
12k views

Error on re-import: #1231 - Variable 'character_set_client' can't be set to the value of 'NULL'

Community's user avatar
CommunityBot
  • 1
2 votes
1 answer
3k views

How to configure AutoMySQLBackup?

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
31 views

Configuring a Failover Cluster Fileshare Witness?

Sean Gallardy's user avatar
Sean Gallardy
  • 28.9k
0 votes
0 answers
12 views

How do I temporarily enable mysql.general_log in AWS Aurora Serverless V2?

Archimedes Trajano's user avatar
Archimedes Trajano
  • 133
1 vote
1 answer
460 views

Connection rejected on MySQL server (error 10060)

Community's user avatar
CommunityBot
  • 1
1 vote
1 answer
1k views

PostgreSQL - Replica Recovery Process Stuck frequently (epoll_wait taking too much time)

Community's user avatar
CommunityBot
  • 1
0 votes
1 answer
27 views

Why use $group / group_by instead of multiple requests?

J.D.'s user avatar
J.D.
  • 34k

Looking for more? Browse the complete list of questions, or popular tags. Help us answer unanswered questions.

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.