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

Top Questions

3 votes
1 answer
5k views

Connection Timeout Expired. The timeout period elapsed while attempting to consume the pre-login handshake acknowledgement

0 votes
0 answers
7 views

Upserts while enforcing uniqueness over a table column, plus a set of joined records

0 votes
1 answer
591 views

SSLServerHasCertificateAuthority is false but the certificate is signed by a trusted CA

0 votes
0 answers
10 views

What is purpose of cluster and sql server ips in FCI

0 votes
0 answers
6 views

Is it possible to configure a postgres DB to send a notification of some kind when a frequent query's execution plan changes?

0 votes
1 answer
15 views

SQL Server, CU's and Server Reboots

0 votes
2 answers
166 views

CSSCAN for the character set change, database version 11.2.0.3.0

-1 votes
1 answer
29 views

Can SQL AG be used across 2 sites over the internet to create replica readonly db on remote server?

0 votes
0 answers
4 views

Transactional Replication Errors - Missing and Duplicate Data at Subscriber

0 votes
1 answer
15 views

I can't bring single data

-1 votes
0 answers
6 views

Generating XSD from a query that generates XML?

0 votes
1 answer
272 views

How to take single database backup using mysqlbackup command in Mysql 8.0.18 version DB

0 votes
1 answer
10 views

PG Admin Sessions

0 votes
0 answers
4 views

GUI for running parameterized Postgres query

0 votes
1 answer
542 views

MySQL Lock Wait Time Out Exceeded upon Delete

0 votes
0 answers
20 views

MS SQL Need Help storing and processing 2 GB + of JSON data

1 vote
2 answers
3k views

Why aggregate query with lookup is extremely slow?

0 votes
1 answer
26 views

How to get the masked user created object id in the master database?

-1 votes
0 answers
8 views

How would I create a sql query that measures the length of both the last name & first name in a table and then groups the count of the records?

0 votes
1 answer
21 views

Does the DEA A/B testing (using trace replay) require the target database migrated/restored and does it update the target database data?

0 votes
1 answer
27 views

How to configure the listener in a read scale SQL AG post failover?

6 votes
2 answers
14k views

MySQL - run SELECT statement on another server without defining the table structure

0 votes
1 answer
17 views

How does sql server know whether the dirty pages have been written to the data file?

0 votes
1 answer
22 views

Unable to change password in postgres even though I'm logged in as that user [duplicate]

0 votes
0 answers
15 views

Apply comparision within group of rows to get one row per group

2 votes
2 answers
44 views

How to order by cumulative value?

0 votes
1 answer
370 views

mysql creating sort index making queries slow

0 votes
0 answers
16 views

How to update records in table based on group by on multiple fields and select first record from each group?

5 votes
3 answers
489 views

Is there a performance penalty when there are two unique indexes on a table with all of the colums in one index are also in the other index?

1 vote
1 answer
3k views

PostgeSQL: create role/user if not exists?

0 votes
1 answer
33 views

SQL Server - how to disable case sensitive in my query window?

1 vote
1 answer
2k views

UserNotFound mongodb error

0 votes
0 answers
15 views

CREATE A NEW COLUMN AND ADD DATA FROM A QUERY

0 votes
1 answer
21 views

Is it not possible to add instance and shared features to a pre-existing FCI?

2 votes
2 answers
1k views

MySQL replication master-slave with 2 or more users in master

0 votes
1 answer
9 views

Postgres SSL client certificate - database server CA failed to start

0 votes
1 answer
960 views

mongodb crashed with the error or permission denied

1 vote
2 answers
37 views

index review for old big instance

-2 votes
1 answer
15 views

PSQL avoid insert failing because a trigger failed

0 votes
0 answers
9 views

How to check if Db2 database is encrypted at rest?

0 votes
1 answer
21 views

ON CONFLICT with index column name is a syntax error

0 votes
3 answers
2k views

before update trigger on sql server

0 votes
1 answer
602 views

Query goes in Copying to tmp table stauts in MySQL and never returns

17 votes
2 answers
9k views

Detect when a CREATE INDEX CONCURRENTLY is finished in PostgreSQL

16 votes
2 answers
17k views
+150

Is there a way to insert multiple rows into a table with default values for all columns?

-3 votes
1 answer
23 views

Where to download a backup of the stack overflow to use for SQL Server 2019

0 votes
1 answer
161 views

ERROR unknown variable > 'keyring_okv_conf_dir=/usr/local/mysql/mysql-keyring-okv'

10 votes
2 answers
919 views

Is there a way to see what were the Candidate Execution Plans generated by the Query Optimizer?


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