Phill  W.'s user avatar
Phill  W.'s user avatar
Phill  W.'s user avatar
Phill W.
  • Member for 8 years, 5 months
  • Last seen this week
17 votes

MySQL: Swap ID between two rows

17 votes

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

14 votes
Accepted

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

11 votes
Accepted

SQL Server with multiple databases (one per client) - what is the best security practice in terms of logins/users/permissions?

9 votes

Log backup vs differential backups

8 votes
Accepted

How do I create a new Oracle schema?

7 votes

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

7 votes

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

6 votes
Accepted

Unlock user shell script for Oracle

6 votes

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

6 votes

Understanding where pg_toast is coming from

5 votes
Accepted

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

5 votes
Accepted

Index columns on pre-production?

5 votes
Accepted

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

5 votes

Should databases be dumped to SQL format or custom archive?

4 votes
Accepted

Design: What should be my PK, FK etc

4 votes

Help - Database design

4 votes

Set up PL/SQL Developer

4 votes

How to add new column based on calculation of another column in postgresql?

4 votes

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

4 votes

Difference between Hints and Indexes

4 votes

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

4 votes
Accepted

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

4 votes

I deleted a folder from /var/lib/mysql and now all of my databases seem to be unaccessible

4 votes

How can I make queries secret?

4 votes

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

4 votes

Disadvantages to using ON DELETE CASCADE on every foreign key?

3 votes
Accepted

Cannot restart or repair mongodb database after the crash (***aborting after invariant() failure)

3 votes
Accepted

Posgres database requires a group by clause. (column \"candidates.id\" must appear in the GROUP BY clause or be used in an aggregate function",)

3 votes

Multiple values for a single column

1
2 3 4 5
21