Hottest Questions Today

0

votes

0

answers

19

views

SQL Server - BackupDiskFile - Referencing to deleted TR Backup file

sql-server

3 hours ago bulat makhmutov 1

0

votes

0

answers

14

views

SQL Sever Alwayson - Increase the WSFC failover threshold

modified 2 hours ago McNets 21.9k

0

votes

1

answer

24

views

Set column of a select query from an array in Postgres

postgresql

modified 2 hours ago Vérace 25.2k

0

votes

1

answer

20

views

create column for a table from select data from another table column

sql-server

answered 5 hours ago Blue sky 1

0

votes

1

answer

12

views

can't backup postgres 13 with pg_dump

postgresql google-cloud-sql

answered 9 mins ago Phill W. 5,288

0

votes

0

answers

20

views

Production filesystem is at 100%. Move the datafiles to a new filesystem?

oracle rman tablespaces datafile file-system

asked 11 hours ago Phillip 11

1

vote

1

answer

46

views

MySql DB slow after restore until I run mysqlcheck

mysql performance query-performance

modified 11 hours ago Ryan Griffith 121

2

votes

1

answer

14

views

Postgres difference between restart_lsn and confirmed_flush

postgresql replication pg-logical

answered 4 hours ago Laurenz Albe 25.6k

0

votes

1

answer

32

views

Calculate Year over Year and Month over Month

google-bigquery

answered 4 hours ago Vérace 25.2k

0

votes

0

answers

16

views

How to improve efficiency of multiple JSON_EXTRACT SELECT expressions

query-performance mariadb json

modified 1 hour ago artfulrobot 397

0

votes

1

answer

21

views

Why scaling up an app by 50x exceed the PostgreSQL max_connection value of 100?

postgresql concurrency docker

answered 7 hours ago jjanes 28.4k

0

votes

2

answers

40

views

How to Sync MySQL Databases when offline?

mysql mariadb master-master-replication maxscale

modified 18 hours ago J.D. 17.8k

0

votes

0

answers

21

views

Need a hand recovering a MySQL InnoDB database

mysql innodb crash

asked 18 hours ago risingfish 101

0

votes

0

answers

14

views

What is the intended method for automatically/streamlinedly updating minor/patch PostgreSQL versions on Windows?

postgresql update windows patching automation

asked 18 hours ago user16508174 207

0

votes

0

answers

25

views

Hidden SQL server replica in always on availablity group

sql-server availability-groups failover

asked 21 hours ago TheDataGuy 1,573

0

votes

0

answers

34

views

How to efficiently deal with high inserts rate and query on multiple columns in PostgreSql 12

postgresql query-performance partitioning index-tuning database-size

asked 23 hours ago iamadnan 1

0

votes

2

answers

15

views

SQL server 2017 distributed availability group connectivity after failover

sql-server availability-groups distributed-availability-groups

answered 16 hours ago David Browne - Microsoft 35.6k

0

votes

1

answer

16

views

Select SDO_GEOMETRY line vertices as rows

oracle spatial oracle-18c geometry

modified 13 hours ago User1973 69

0

votes

1

answer

23

views

MySQL select all the ids with the same column value

mysql

modified 21 hours ago Andrew Sayer 1,120

0

votes

1

answer

55

views

Does putting constraints decrease the required size to store my data in SQL Server?

sql-server database-design constraint check-constraints

answered yesterday David Browne - Microsoft 35.6k

1

vote

1

answer

78

views

Why does a Full Backup restore of my database give me the error "RESTORE can only create a database when restoring either a full backup..."?

sql-server backup restore transaction-log sql-server-2019

answered 20 hours ago Tibor Karaszi 11.2k

-1

votes

2

answers

22

views

How can I mysqldump all databases except the mysql schema In Windows

mysql mysqldump

answered yesterday Rick James 63.3k

0

votes

2

answers

104

views

SQL Server - Deadlock during two concurrent DELETE

sql-server deadlock

modified yesterday David Browne - Microsoft 35.6k

7

votes

3

answers

1k

views

How to know which application or user put the SQL Server Database in single user mode

sql-server locking

modified Sep 15 at 14:06 John K. N. 13.7k

-1

votes

0

answers

41

views

Relational database with Kafka-like durability/caching implementation

database-design replication query-performance kafka

asked yesterday Krzysztof Nawara 1

0

votes

1

answer

46

views

Count and last row of a batch(Top) with a insert statement

sql-server sql-server-2019

modified 2 days ago McNets 21.9k

5

votes

1

answer

150

views

Index Definition Order and ORDER BY Clause

sql-server index order-by

modified 2 days ago Paul White♦ 62.7k

0

votes

1

answer

11

views

mysql/mariadb replication with proxy

replication mariadb mysql-proxy

answered 12 hours ago danblack 5,779

7

votes

2

answers

383

views

SQL Server 2017 - CU25 - sp_pkeys - Wrong order

sql-server sql-server-2017

answered 2 days ago db2222 93

4

votes

1

answer

48

views

INSERT ON CONFLICT DO NOTHING efficiency (PostgreSQL)

postgresql postgresql-performance

answered yesterday Laurenz Albe 25.6k

10

votes

1

answer

157

views

Could I have an undetected deadlock?

sql-server sql-server-2017 deadlock

answered 2 days ago mv ٠〳comment ٠〳answer 637

2

votes

1

answer

63

views

OBJECT_ID(...) function vs join on sys.tables and sys.schemas

sql-server metadata system-tables

modified 2 days ago mv ٠〳comment ٠〳answer 637

1

vote

1

answer

37

views

PostgreSQL Query Optimization - Joining with a lookup table does not use index

postgresql query-performance index join postgresql-performance

modified yesterday mustaccio 19.1k

0

votes

1

answer

25

views

Strange selection pushdown in postgres 13

postgresql

answered yesterday Laurenz Albe 25.6k

1

vote

2

answers

54

views

Avoid Deadlock on concurrent insert

mysql innodb mysql-8.0 concurrency

modified yesterday Andriy Lysak 115

0

votes

2

answers

24

views

MYSQL LOAD DATA INFILE giving ERROR 1265

mysql

answered yesterday nnonname 1

2

votes

2

answers

62

views

Why is this SQL query with UNION significantly faster than the same query without?

postgresql postgresql-performance union postgresql-12

modified 2 days ago laurent 123

0

votes

1

answer

60

views

Number of executions of the same sub query by the DB engine

sql-server t-sql

modified 2 days ago Hannah Vernon♦ 66.1k

0

votes

0

answers

22

views

How to troubleshoot SQLServerAgent startup

sql-server sql-server-2017

modified 8 hours ago a1ex07 8,561

0

votes

1

answer

38

views

Sudden Insertion Error to a 3 years old table with 5 million of records - Mysql error 1452 - Insert Problem

mysql mariadb

answered 2 days ago Rick James 63.3k

0

votes

0

answers

27

views

AND clause with IN function to compare/validate values from subquery

oracle plsql

asked 2 days ago KSS_07 11

0

votes

1

answer

18

views

Show more details on Postgres logical replication errors

postgresql pg-logical

answered yesterday Laurenz Albe 25.6k

0

votes

1

answer

21

views

MYSQL Error 1064 on INSERT INTO with CTE

mysql insert cte

modified 2 days ago Bill Karwin 7,600

0

votes

1

answer

31

views

Best practise to compute total amount from individual entries

database-design update sum

modified 2 days ago Vérace 25.2k

0

votes

1

answer

25

views

Why does mysql join strategy depend on this value?

mysql performance join

answered 2 days ago Rick James 63.3k

0

votes

0

answers

32

views

load large data and split and store into two tables in sql server

sql-server migration python

modified 2 days ago vishnu padmanabhan 1

2

votes

1

answer

60

views

MS SQL attach MDF/LDF without FileTable folder

sql-server filetable

answered Sep 17 at 10:20 Rob Dalzell 484

Top Questions

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