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 2 Bountied Hot Week Month

0

votes

0

answers

3

views

Retrieving the last log. Asking for best practices. postgres, 4.5mil rows

postgresql query-performance

asked 27 mins ago igal leikin 1

0

votes

0

answers

7

views

Are SQL Security Updates Cumulative? Are the vulnerabilities corrected with one Security Update also covered by the next Security Update?

sql-server-2014 patching

asked 1 hour ago Sergio Cerdas 1

1

vote

1

answer

347

views

Robust way to build a DWH without downtime

postgresql data-warehouse

modified 1 hour ago CommunityBot 1

0

votes

1

answer

12

views

Can Power BI change data in the database?

mysql powerbi

answered 1 hour ago mustaccio 19.3k

0

votes

3

answers

46

views

Reduce rows read by the database engine for this aggregate query

sql-server query-performance execution-plan

modified 1 hour ago Hannah Vernon♦ 66.3k

0

votes

1

answer

21

views

I have permission to the table, but not to a view that uses the table

postgresql permissions

answered 2 hours ago jjanes 29k

0

votes

2

answers

12

views

What do I need to put in pfile to change NLS_CHARACTERSET?

oracle-12c docker

answered 2 hours ago sarat 52

1

vote

1

answer

568

views

How to count between two users unread messages in SQL

mysql

modified 2 hours ago CommunityBot 1

0

votes

0

answers

46

views

SQL Server: Nested IF 3 level

sql-server

modified 2 hours ago Hannah Vernon♦ 66.3k

148

votes

12

answers

88k

views

Should binary files be stored in the database?

database-design blob

modified 2 hours ago henke37 3

0

votes

1

answer

848

views

WordPress MySQL writes during "Flush Tables With Read Lock" are rejected instead of being queued

mysql backup myisam mysql-5.1

modified 2 hours ago BenMorel 646

0

votes

0

answers

9

views

Oracle simple count(*) SQL query takes "forever"

oracle oracle-12c count

asked 2 hours ago ggo 99

0

votes

0

answers

2

views

What does MISSING_TARGET means on Amazon DMS (Database Migration Service) validation?

migration amazon-dms

asked 2 hours ago Kokizzu 1,107

3

votes

1

answer

153

views

Can optional foreign key cause trouble in the long term?

sql-server foreign-key

modified 3 hours ago Aleksey Vitsko 3,925

Browse more Questions

Database Administrators Stack Exchange works best with JavaScript enabled