Oracle Patching – PSU or CPU ?

Any clue don’t use PSU (Patch Set Updates) ?

As described in Oracle Metalink Note 854428.1 switch back to CPU “…would require significant effort, and so is not advised”.

Please comment.

Performance Issues After Migration To SQL 2005

During reading support forums i found many issues related to performance after migrating to SQL 2005.

Some advice to increase performance:

- Rebuild indexes (DBCC DBREINDEX)

- Update statistics (SP_UPDATESTATS)

- Check the compatibility level of the database in question.

If the compatibility level is set to 80 (SQL 2000)  change it to 90 (SQL 2005).

The compatibility level is not really related to performance but needed for use new features released with SQL 2005.