User Joe

77 votes

Accepted

Can't rename columns in PostgreSQL views with CREATE OR REPLACE

answered Jan 13, 2011 at 2:19

32 votes

How can I move a database from one server to another?

answered Jan 4, 2011 at 16:38

16 votes

What are the main causes of deadlocks and can they be prevented?

answered Jan 4, 2011 at 15:31

16 votes

Accepted

What is the difference between MySQL VARCHAR and TEXT data types?

answered Jan 8, 2011 at 12:49

15 votes

Accepted

How can I query names using regular expressions?

answered Jan 4, 2011 at 3:24

14 votes

Accepted

What is your workflow for planning a data migration?

answered Feb 25, 2011 at 22:51

13 votes

Is it better to store images in a BLOB or just the URL?

answered Jan 20, 2011 at 17:48

12 votes

MySQL data type for 128 bit integers

answered Jan 29, 2011 at 4:33

12 votes

The Value of Certifications

answered Jan 4, 2011 at 19:29

12 votes

Storing vs calculating aggregate values

answered Jan 5, 2011 at 1:44

12 votes

How do I find PostgreSQL's data directory?

answered Feb 21, 2011 at 3:12

11 votes

Accepted

Security for Application Developers doing PL/SQL work in Oracle

answered Jan 5, 2011 at 19:15

11 votes

Accepted

Emulate REGEXP like behaviour in DB2 SQL

answered Jan 17, 2011 at 14:18

10 votes

What problems will I get creating a database per customer?

answered Feb 3, 2011 at 12:25

10 votes

Software Engineers and DBAs

answered Feb 3, 2011 at 12:54

10 votes

How do convert a 66,862,521 row table from MyISAM to InnoDB without going offline for several hours?

answered Jan 9, 2011 at 17:05

10 votes

Accepted

Securing DB passwords

answered Jan 4, 2011 at 4:35

9 votes

Should you design the database before the application code is written?

answered Oct 13, 2011 at 15:55

7 votes

Where should one put indexes in a time dimension table?

answered Jan 10, 2011 at 16:37

6 votes

Accepted

different login credentials based on user

answered Jan 5, 2011 at 18:48

6 votes

Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0

answered Feb 25, 2011 at 13:26

6 votes

Accepted

A database for digital assets

answered Feb 23, 2011 at 1:54

5 votes

Accepted

Proper technique for storing users event data

answered Jul 22, 2011 at 19:59

5 votes

What should I ask at a MySQL DBA interview?

answered Sep 28, 2011 at 16:44

5 votes

What is the recommended RAID configuration for an Oracle database?

answered Jan 6, 2011 at 14:35

5 votes

What is the difference between terminating an Oracle sql statement with semicolon or with a slash on the next line?

answered Feb 18, 2011 at 13:57

4 votes

Why is OS authentication considered poor security for Oracle databases?

answered Jan 28, 2011 at 11:37

4 votes

How can I SELECT an 'entry' that spans adjacent months?

answered Feb 5, 2011 at 2:47

4 votes

Accepted

Can you "su -" in MySQL?

answered Jan 11, 2011 at 22:28

4 votes

Are there any database engines which will intuit the join condition based on the existing foreign keys?

answered Jan 7, 2011 at 17:11

Stack Exchange Network

54 Answers

Can't rename columns in PostgreSQL views with CREATE OR REPLACE

How can I move a database from one server to another?

What are the main causes of deadlocks and can they be prevented?

What is the difference between MySQL VARCHAR and TEXT data types?

How can I query names using regular expressions?

What is your workflow for planning a data migration?

Is it better to store images in a BLOB or just the URL?

MySQL data type for 128 bit integers

The Value of Certifications

Storing vs calculating aggregate values

How do I find PostgreSQL's data directory?

Security for Application Developers doing PL/SQL work in Oracle

Emulate REGEXP like behaviour in DB2 SQL

What problems will I get creating a database per customer?

Software Engineers and DBAs

How do convert a 66,862,521 row table from MyISAM to InnoDB without going offline for several hours?

Securing DB passwords

Should you design the database before the application code is written?

Where should one put indexes in a time dimension table?

different login credentials based on user

Is where x = 0 or x is null to be replaced by where isnull(x, 0) = 0 resp. where NVL(x, 0) = 0

A database for digital assets

Proper technique for storing users event data

What should I ask at a MySQL DBA interview?

What is the recommended RAID configuration for an Oracle database?

What is the difference between terminating an Oracle sql statement with semicolon or with a slash on the next line?

Why is OS authentication considered poor security for Oracle databases?

How can I SELECT an 'entry' that spans adjacent months?

Can you "su -" in MySQL?

Are there any database engines which will intuit the join condition based on the existing foreign keys?