Database Administrators Stack Exchange

0

votes

0

answers

6

views

Avoid duplicate WHERE clause on both sides of a LEFT JOIN, without changing semantics or impairing query optimization

postgresql query-performance optimization

asked 27 mins ago zwol 221

1

vote

2

answers

25

views

Unexpected behaviour for GROUP BY query

postgresql group-by aggregate postgresql-9.4

modified 53 mins ago Erwin Brandstetter 119k

2

votes

2

answers

284

views

Deadlocks With Trigger Based Replication

oracle replication trigger deadlock

modified 57 mins ago Community♦ 1

0

votes

0

answers

3

views

Postgresql update performance

postgresql

asked 1 hour ago Rafael Ferreira Rocha 101

1

vote

1

answer

21

views

How to create index to improve performance of an aggregate function that creates a table in oracle

oracle optimization aggregate plsql oracle-apex

modified 1 hour ago Josh 11

0

votes

0

answers

12

views

db choice for activity log

replication data-warehouse high-availability database-recommendation storage

modified 1 hour ago Federico Bevione 1

5

votes

1

answer

498

views

How are the system health extended events files rolling over?

sql-server sql-server-2012 sql-server-2014 extended-events

modified 1 hour ago Josh Darnell 20.3k

0

votes

1

answer

93

views

insert multi on a table handled by trigger

mysql trigger

modified 2 hours ago Community♦ 1

1

vote

0

answers

12

views

Active Directory Name Change

sql-server security windows-server authentication logins

asked 2 hours ago SQL_NoExpert 909

0

votes

1

answer

29

views

Why are CASE-expressions in the list documenting operator precedence?

mysql mariadb syntax parse

modified 2 hours ago JoL 279

1

vote

2

answers

101

views

Help combining two MySQL queries to improve performance

mysql subquery

modified 2 hours ago Community♦ 1

0

votes

2

answers

144

views

ibdata1 recovery mysql failed

mysql

answered 3 hours ago Phill W. 3,381

3

votes

3

answers

9k

views

Pushing or appending to JSON array in PostgreSQL 9.4

postgresql postgresql-9.4 json array

answered 3 hours ago Rajan Brahma 11

0

votes

0

answers

46

views

SSRS 2019 with an oracle data source

ssrs reporting ssrs-2019

modified 3 hours ago James 1

Jun	JUL	Aug
	31
2019	2020	2021

Stack Exchange Network

current community

your communities

more stack exchange communities

Explore our Questions

Avoid duplicate WHERE clause on both sides of a LEFT JOIN, without changing semantics or impairing query optimization

Unexpected behaviour for GROUP BY query

Deadlocks With Trigger Based Replication

Postgresql update performance

How to create index to improve performance of an aggregate function that creates a table in oracle

db choice for activity log

How are the system health extended events files rolling over?

insert multi on a table handled by trigger

Active Directory Name Change

Why are CASE-expressions in the list documenting operator precedence?

Help combining two MySQL queries to improve performance

ibdata1 recovery mysql failed

Pushing or appending to JSON array in PostgreSQL 9.4

SSRS 2019 with an oracle data source

Hot Network Questions