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

Explore our Questions

Ask Question

more tags

Active 3 Bountied Hot Week Month

0

votes

1

answer

259

views

mysql/aurora not immediately seeing results of committed transactions

mysql amazon-rds concurrency aws-aurora amazon-rds-aurora

modified 2 mins ago Community♦ 1

0

votes

1

answer

4

views

replace user defined functions (UDF) and tabled value functions(TVF)

sql-server-2016 functions set-returning-functions

answered 8 mins ago KASQLDBA 6,635

12

votes

2

answers

16k

views

postgres - pg_dump and pg_restore without roles

postgresql postgresql-9.3 pg-dump

answered 27 mins ago Duke 101

3

votes

1

answer

32

views

Suddenly SQL server restarted with pending task count increased

sql-server performance sql-server-2012

modified 48 mins ago BeginnerDBA 1,861

0

votes

1

answer

392

views

MySQL server Load is 100% CPU

mysql linux memory ubuntu

modified 1 hour ago Community♦ 1

0

votes

1

answer

2k

views

How to Recover My database From Old WampServer?

mysql mysql-5.6 upgrade wamp

modified 1 hour ago Community♦ 1

0

votes

1

answer

37

views

Eliminate filter operator before columnstore index scan operator

sql-server t-sql sql-server-2017 index-tuning columnstore

modified 1 hour ago Avi 200

0

votes

1

answer

27

views

Why does our MySQL server become non-responsive with the processlist showing tons of processes waiting in STATE=init, INFO=commit?

mysql mysql-5.6

answered 2 hours ago Rick James 55.5k

12

votes

2

answers

10k

views

PostgreSQL: Immutable, Volatile, Stable

postgresql terminology

modified 2 hours ago jberryman 399

2

votes

1

answer

22

views

MySQL Client can Connect but Replication Slave Can't

mysql linux

answered 2 hours ago garys 16

0

votes

2

answers

85

views

Want to delete then insert with single statement using a CTE in Postgres

postgresql cte

modified 2 hours ago Community♦ 1

0

votes

0

answers

12

views

Running sp_BlitzCache on remote server

sql-server sp-blitzcache

modified 3 hours ago Mihir Rane 1

0

votes

1

answer

10

views

SQL - Date Range Broken Down by Individual Month and Year while maintaining the ID

date

modified 3 hours ago Scott Hodgin 22.4k

0

votes

1

answer

155

views

Replication using Datagaurd to FAR DR

oracle replication dataguard

modified 3 hours ago Community♦ 1

Browse more Questions

Database Administrators Stack Exchange works best with JavaScript enabled