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

0 votes
1 answer
11 views

ON CONFLICT with index column name is a syntax error

0 votes
1 answer
23 views

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

5 votes
3 answers
180 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 votes
1 answer
12 views

SQL Server Stored Procedure misbehave

3 votes
1 answer
94 views

Implement foreign key constraint when there are several parent tables

1 vote
0 answers
14 views

Is this DB design correct?

-2 votes
0 answers
11 views

PSQL avoid insert failing because a trigger failed

6 votes
1 answer
738 views

How to get a user's password in PostgreSQL?

2 votes
1 answer
240 views

How much resources does a sleeping connection require in SQL Server?

2 votes
2 answers
153 views

Does large tempdb file size have impact on sql server startup time?

0 votes
0 answers
18 views

What is the type of relationship of the below ER diagram?

1 vote
0 answers
19 views

Upgrade Replication MySQL from 5.7.34 to 8.0.28 without database downtime

0 votes
0 answers
33 views

"There is insufficient system memory in resource pool 'default' to run this query" error with MEMORY_OPTIMIZED tables

0 votes
0 answers
11 views

Why am I getting error: Error Code: 1822. Failed to add the foreign key constraint. Missing index for constraint

1 vote
1 answer
21 views

When do you need to run Analyze Table on MariaDB?

1 vote
0 answers
24 views

Long temp table TRUNCATE

0 votes
0 answers
14 views

pg_dump taking lot of time for tables with TOAST entries

0 votes
1 answer
14 views

In postgres unable to create database

0 votes
0 answers
16 views

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

0 votes
1 answer
22 views

Whether the latest GDR from Microsoft includes all prior GDRs?

5 votes
2 answers
203 views

Advantage of "LOAD DATA ... REPLACE INTO TABLE" over "UPDATE table_name SET"

0 votes
0 answers
12 views

Creating Copy of Cassandra Source Cluster

0 votes
0 answers
21 views

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

0 votes
0 answers
13 views

Is there a difference in performance loading different datatypes

-3 votes
0 answers
24 views

Assuming I am on the GDR train, then what would be the use case of applying CU16-GDR or CU16? [duplicate]

0 votes
1 answer
15 views

What units are wait times in MySQL performance schema?

0 votes
0 answers
12 views

Data source to extract millions of rows of data out of hundreds of excel files which can be DirectQueried

0 votes
0 answers
12 views

Syntax error near declare statement Cursor %TYPE

0 votes
0 answers
18 views

SQL Server - Access denied when reading a file from Azure Blob Storage container using SAS key

0 votes
0 answers
13 views

Create oracle scheduler fails

-2 votes
0 answers
32 views

Synchronizing indexes between databases

-1 votes
0 answers
13 views

how to fix the problem in creating sales table

1 vote
1 answer
28 views

How to format a fixed-length number as a binary string?

3 votes
1 answer
215 views

Is this valid SQL Server Update syntax?

2 votes
0 answers
54 views

Postgresql full text search without diacritics (effective unaccent)

-1 votes
1 answer
31 views

Does SQL Server support join type "LEFT SEMI JOIN" in your query?

1 vote
0 answers
17 views

MySQL from backup won't start due to possibly corrupted data folder or permissions

0 votes
1 answer
28 views

If a table column corresponding to different target columns in different tables, how to join this column in SQL?

1 vote
2 answers
39 views

How to order by cumulative value?

0 votes
1 answer
19 views

What is the use case difference between forced quorum and force cluster to start without quorum?

1 vote
3 answers
26 views

How to index a table using column of another table having relation with it?

0 votes
0 answers
17 views

After upgrade Node not joining galera cluster

8 votes
2 answers
451 views

MS SQL Server DB Transaction Log Growth Rate

0 votes
1 answer
22 views

Performance Quetions. Search database with range query or with and id

6 votes
3 answers
700 views

How does this piece of TSQL work?

-1 votes
1 answer
44 views

SQL Server 2014: Why is Clustered Index Rebuild MUCH faster than initial index creation?


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