Question: We all have our favourite database. If you look objectively at your chosen database, what drawbacks does it have and what could be improved?

The rules:

* One reply per drawback with;
* a short description of the limitation, followed by;
* a more detailed description, an explanation of how it could be done better or an example of another technology that does not have the same limitation.
* Do not diss any database that you haven't used extensively. It is easy to take potshots at other technologies but we want to learn form your experience, not your prejudice.

Answer: 
I love the flexibility of sequences in Oracle as compared with other databases autoincrements, but the inability to set seq.nextval as a default for a pk column is somewhat annoying, and must be trivial to fix.
**Database** Microsoft SQL Server 2005

**Defect** Lack of array type parameters

**Description**

Useful in searches, a lot of times you need to pass a series of values to be matched against. In SQL 2005 you can do a workaround by using CLR inside SQLServer. Given the usefulness it would make more sense to have this feature out of the box.

This does not happen with SQL Server 2008 or Oracle.