Skip to main content
Gaius's user avatar
Gaius's user avatar
Gaius's user avatar
Gaius
  • Member for 13 years, 5 months
  • Last seen more than 1 year ago
35 votes

What are the main differences between InnoDB and MyISAM?

30 votes

How do I find out if a procedure or function exists in a mysql database?

24 votes
Accepted

Why does importing a 12 GB .sql file take more than 36 hours?

23 votes
Accepted

Why use an int as a lookup table's primary key?

23 votes
Accepted

What are database statistics, and how can I benefit from them?

20 votes

How could DBAs be more 'programmer friendly'?

19 votes

What are the arguments against or for putting application logic in the database layer?

19 votes

SQL Server Cannot drop database <dbname> because it is currently in use... but no sessions displayed

19 votes

In MySQL, does the order of the columns in a WHERE clause affect query performance?

17 votes

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

17 votes
Accepted

Find out what queries are causing the biggest amount of network traffic

16 votes
Accepted

Why is OS authentication considered poor security for Oracle databases?

16 votes
Accepted

Why do we need to backup Oracle archive logs along with datafiles

15 votes
Accepted

How do you tune MySQL for a heavy InnoDB workload?

14 votes

Best way to delete very large recordset in Oracle

14 votes
Accepted

SQL Server Deadlock Graph - Table, Page or Row Lock?

13 votes

How to differentiate between SQL and PL/SQL?

12 votes
Accepted

Comfortable sqlplus interface?

12 votes
Accepted

When to use XML data type

11 votes
Accepted

Where does the magic column "name" come from?

11 votes

Resources for SQL Server developer migrating to Oracle

10 votes

Rebuild large Oracle 10g index with insufficient TEMP space?

10 votes

In Oracle how do I save a sequence.nextval in a variable to be reused in multiple inserts?

10 votes
Accepted

Flashback feature in Oracle 11g?

9 votes
Accepted

In Oracle, can we restore a database onto the same instance with a different name?

9 votes

large data movement

9 votes

How do I Create Tablespace in Oracle 11g?

9 votes

What tools are there for data masking? (MySQL, Linux)

8 votes

MySQL : DROP TABLE Starting with a Prefix

8 votes

Is it possible to use SQLite as a client-server database?

1
2 3 4 5
7