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 3 Bountied Hot Week Month
0 votes
1 answer
11 views

ON CONFLICT with index column name is a syntax error

Lennart - Slava Ukraini
  • 22k
0 votes
1 answer
23 views

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

Harry
  • 566
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?

Paul White♦
  • 73.7k
-1 votes
1 answer
12 views

SQL Server Stored Procedure misbehave

MBuschi
  • 3,695
3 votes
1 answer
94 views

Implement foreign key constraint when there are several parent tables

Laurenz Albe
  • 35.4k
1 vote
0 answers
14 views

Is this DB design correct?

Dasith
  • 111
-2 votes
0 answers
11 views

PSQL avoid insert failing because a trigger failed

Eugenio.Gastelum96
  • 1
6 votes
1 answer
738 views

How to get a user's password in PostgreSQL?

tinlyx
  • 3,025
2 votes
1 answer
240 views

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

Sean Gallardy - Mostly Retired
  • 24.3k
2 votes
2 answers
153 views

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

MBuschi
  • 3,695
0 votes
0 answers
18 views

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

David Browne - Microsoft
  • 41.7k
1 vote
0 answers
19 views

Upgrade Replication MySQL from 5.7.34 to 8.0.28 without database downtime

David Browne - Microsoft
  • 41.7k
0 votes
0 answers
33 views

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

Dan Guzman
  • 24.7k
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

Aaron Gibney
  • 1
1 vote
1 answer
21 views

When do you need to run Analyze Table on MariaDB?

Rick James
  • 70.5k
1 vote
0 answers
24 views

Long temp table TRUNCATE

aqis
  • 11
0 votes
0 answers
14 views

pg_dump taking lot of time for tables with TOAST entries

Mukul Gupta
  • 115
0 votes
1 answer
14 views

In postgres unable to create database

Laurenz Albe
  • 35.4k
0 votes
0 answers
16 views

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

variable
  • 2,866
0 votes
1 answer
22 views

Whether the latest GDR from Microsoft includes all prior GDRs?

SEarle1986
  • 1,600
5 votes
2 answers
203 views

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

Ergest Basha
  • 1,807
0 votes
0 answers
12 views

Creating Copy of Cassandra Source Cluster

CassandraNovice
  • 11
0 votes
0 answers
21 views

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

Fajela Tajkiya
  • 543
0 votes
0 answers
13 views

Is there a difference in performance loading different datatypes

a_horse_with_no_name
  • 73.3k
-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]

variable
  • 2,866
0 votes
1 answer
15 views

What units are wait times in MySQL performance schema?

Dai
  • 466
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

Burd
  • 1
0 votes
0 answers
12 views

Syntax error near declare statement Cursor %TYPE

Hardik Patil
  • 101
0 votes
0 answers
18 views

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

Dustine Tolete
  • 109
0 votes
0 answers
13 views

Create oracle scheduler fails

padjee
  • 41
-2 votes
0 answers
32 views

Synchronizing indexes between databases

Paul White♦
  • 73.7k
-1 votes
0 answers
13 views

how to fix the problem in creating sales table

Akina
  • 17.6k
1 vote
1 answer
28 views

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

Erwin Brandstetter
  • 157k
3 votes
1 answer
215 views

Is this valid SQL Server Update syntax?

ypercubeᵀᴹ
  • 93.8k
2 votes
0 answers
54 views

Postgresql full text search without diacritics (effective unaccent)

Trigve
  • 21
-1 votes
1 answer
31 views

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

SqlWorldWide
  • 12.4k
1 vote
0 answers
17 views

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

valepu
  • 111
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?

J.D.
  • 26.7k
1 vote
2 answers
39 views

How to order by cumulative value?

Erwin Brandstetter
  • 157k
0 votes
1 answer
19 views

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

SqlWorldWide
  • 12.4k
1 vote
3 answers
26 views

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

Charlieface
  • 7,711
0 votes
0 answers
17 views

After upgrade Node not joining galera cluster

faheem
  • 1
8 votes
2 answers
451 views

MS SQL Server DB Transaction Log Growth Rate

Aleksey Vitsko
  • 4,910
0 votes
1 answer
22 views

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

J.D.
  • 26.7k
6 votes
3 answers
700 views

How does this piece of TSQL work?

Aleksey Vitsko
  • 4,910
-1 votes
1 answer
44 views

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

MattM
  • 36

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.