Check this article on Microsoft site which improves performance of SQL server hosting Project database
Improve performance of SQL2000 server if the server has case-insensitive collation and is hosting a Project Server 2003 database
http://support.microsoft.com/kb/906687