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
15 views

Consolidating Similar Indexes?

0 votes
1 answer
12 views

MySQL incorrect equality casting bigint to char

-1 votes
0 answers
12 views

SQL Server - Example queries for the WideWorldImporters sample database

0 votes
1 answer
11 views

Find in what table I can find multiple collumns

-3 votes
0 answers
35 views

SQL Server 2019 Blue Question Mark in Remote SSMS

2 votes
0 answers
12 views

SQL Server 2014 SP3 Backup to URL error

3 votes
5 answers
332 views

Return NULL when distinct values else return value

-2 votes
1 answer
19 views

Is it possible to access a Windows MSSQL server from an instance of Linux?

0 votes
1 answer
11 views

oracle - Calculate sum or avg in one query based on the their value

0 votes
0 answers
20 views

A transport-level error has occurred when receiving results from the server. An existing connection was forcibly closed by the remote host

2 votes
1 answer
87 views

SQL Server PATINDEX issue/bug when using different case-sensitive collations

0 votes
1 answer
20 views

Is `innodb_table_locks=0` a good idea?

0 votes
0 answers
17 views

Postgres - how to automatically kill a 'hung' session?

-1 votes
0 answers
14 views

PostgreSQL vs MongoDB which is better in storing Json data and retrieval and perform query operations [closed]

0 votes
1 answer
20 views

Manually change datafile size or let oracle do the job during schema duplication

2 votes
0 answers
60 views

Is this the correct way to select with updlock and then conditionally insert?

0 votes
1 answer
23 views

How to query nested unamed jsonb objects and order?

0 votes
1 answer
27 views

ola hallengren @databasesinparallel parameter on Azure SQLServer

2 votes
2 answers
297 views

Is a clustered index of 3 columns too big?

1 vote
0 answers
30 views

How to change data type of PK for very min to no maintenance while performing this action

-2 votes
1 answer
40 views

Can't create MS SQL Server trigger

0 votes
2 answers
20 views

How to make unstructured array of object to row?

-3 votes
4 answers
62 views

Automate SQL Server reports and send them by mail

0 votes
0 answers
24 views

How to create index for jsonb key existence?

5 votes
2 answers
270 views

Records greater than epoch timestamp using only LIKE operator

-1 votes
0 answers
16 views

Run multiple scripts on multiple databases/servers using Try catch method with output for each individual script

0 votes
1 answer
30 views

How does instagram handle top likes when there are millions of likes for a particular post?

0 votes
1 answer
20 views

Multi master vs leader-follower

26 votes
1 answer
2k views

Why MERGE doesn't insert more than 277 records into a table which is configured with temporal table and a non-clustered index on history table

1 vote
2 answers
37 views

Load huge mysqldump (500G)

0 votes
2 answers
16 views

Optimizing querying for any of multiple terms in string

0 votes
0 answers
16 views

How to set max_execution_time during mysqldump

-3 votes
0 answers
19 views

Trying to create a table in postgresql column "" of relation "" does not exist [closed]

0 votes
0 answers
12 views

AWS PostgreSQL RDS read-replica replication failing and lagging

0 votes
0 answers
27 views

Why UPDATEs are faster when WHERE key is sorted in SQLite? How to improve performance?

4 votes
1 answer
178 views

Can PostgreSQL use indexes to expedite count(distinct) queries?

-3 votes
0 answers
57 views

SQL FOR Calculate Month & Year Wise Closing

-1 votes
1 answer
37 views

How sum over work

0 votes
0 answers
42 views

Count the number of rows returned by the query

0 votes
1 answer
60 views

Query to find the count of active days (days with status = ON) between specified dates

2 votes
0 answers
82 views

Sys.dm_os_performance_counters DMV row counts

0 votes
1 answer
66 views

SQL Server - Find Memory ALLOCATED vs. Memory ACTUALLY USED

2 votes
0 answers
23 views

Is there a way to use time series databases effectively without absolute timestamps?

3 votes
1 answer
42 views

gin index 'tid' array does not match table array

0 votes
1 answer
17 views

pt-online-schema-change failed when creating new tablle, specified key was too long; max key length is 767 bytes issue

0 votes
1 answer
20 views

Alternate options for REORG...LONGLOBDATA for space management

2 votes
1 answer
113 views

Can I delete these SQL Server files to clear up disk space?


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