User Phill W.

17 votes

MySQL: Swap ID between two rows

answered Aug 4, 2021 at 13:09

17 votes

How can I improve the performance of where clause with LIKE %abc?

answered Dec 9, 2021 at 9:12

14 votes

Accepted

How do database operations (write, update, alter) on particular cell in a table are written to disk without overwriting entire file?

answered Apr 16, 2019 at 10:59

9 votes

Log backup vs differential backups

answered Feb 10, 2020 at 12:26

8 votes

Accepted

How do I create a new Oracle schema?

answered Oct 23, 2020 at 10:45

7 votes

Same query, different result (depending on user's permissions)

answered Nov 15, 2019 at 11:29

6 votes

How to get psql to prompt for a password with the superuser postgres?

answered Dec 31, 2018 at 11:52

6 votes

Accepted

Unlock user shell script for Oracle

answered Feb 8, 2019 at 11:42

6 votes

How to hide/disable tables without dropping them to check redundancy?

answered May 17, 2016 at 11:38

5 votes

Accepted

Why might a parallel pg_restore command take hours longer to complete its non-parallel equivalent?

answered Aug 1, 2018 at 10:52

5 votes

Accepted

Index columns on pre-production?

answered Nov 1, 2018 at 11:48

5 votes

Should databases be dumped to SQL format or custom archive?

answered Jan 4, 2022 at 15:33

4 votes

Help - Database design

answered Jan 3 at 16:00

4 votes

Set up PL/SQL Developer

answered Jan 26 at 11:25

4 votes

How can I make queries secret?

answered Dec 2, 2020 at 13:03

4 votes

Difference between Hints and Indexes

answered Oct 11, 2018 at 12:42

4 votes

What is the best smallest data type size for 19 digit number?

answered Aug 16, 2018 at 9:55

4 votes

What factors do we need to consider in order to enable auto-growth settings for my PROD database

answered Oct 31, 2019 at 15:25

4 votes

Accepted

Optimizing single-row DELETEs from a table with many FOREIGN KEY references

answered Jun 13, 2019 at 11:03

4 votes

Why is there automatic failover for HA and manual failover for DR?

answered Oct 19, 2020 at 15:31

4 votes

Understanding where pg_toast is coming from

answered Apr 9, 2020 at 14:47

4 votes

Accepted

Oracle - Is a separate database more secure than using the same database and a separate schema

answered Jul 3, 2020 at 12:36

3 votes

I have to write query based on cases can i write like this

answered Feb 22, 2022 at 16:07

3 votes

How to log deadlocks for each database separately

answered Mar 25, 2022 at 13:48

3 votes

Accepted

mysql backup password without root home

answered Apr 5, 2022 at 13:56

3 votes

How to recover from a SQL server log file drive crash?

answered May 18, 2022 at 12:33

3 votes

Accepted

How to automatically rollback a transaction?

answered Aug 8, 2022 at 9:00

3 votes

Accepted

Restrict access to certain tables for users who have DBA roles?

answered Oct 26, 2022 at 14:21

3 votes

Accepted

Select and prepare data on backend or make the finetuning on frontend? Performance | Best Practise

answered Nov 7, 2022 at 13:59

3 votes

Why is the database size larger than sum of table sizes

answered Jul 8, 2020 at 11:16

Stack Exchange Network

534 Answers

MySQL: Swap ID between two rows

How can I improve the performance of where clause with LIKE %abc?

How do database operations (write, update, alter) on particular cell in a table are written to disk without overwriting entire file?

Log backup vs differential backups

How do I create a new Oracle schema?

Same query, different result (depending on user's permissions)

How to get psql to prompt for a password with the superuser postgres?

Unlock user shell script for Oracle

How to hide/disable tables without dropping them to check redundancy?

Why might a parallel pg_restore command take hours longer to complete its non-parallel equivalent?

Index columns on pre-production?

Should databases be dumped to SQL format or custom archive?

Help - Database design

Set up PL/SQL Developer

How can I make queries secret?

Difference between Hints and Indexes

What is the best smallest data type size for 19 digit number?

What factors do we need to consider in order to enable auto-growth settings for my PROD database

Optimizing single-row DELETEs from a table with many FOREIGN KEY references

Why is there automatic failover for HA and manual failover for DR?

Understanding where pg_toast is coming from

Oracle - Is a separate database more secure than using the same database and a separate schema

I have to write query based on cases can i write like this

How to log deadlocks for each database separately

mysql backup password without root home

How to recover from a SQL server log file drive crash?

How to automatically rollback a transaction?

Restrict access to certain tables for users who have DBA roles?

Select and prepare data on backend or make the finetuning on frontend? Performance | Best Practise

Why is the database size larger than sum of table sizes