Re: Oracle performance with Microsoft Project

> Nothing to do with tuning the server engine. The above are general
> application design tuning tasks. We should do those in ANY database and they
> will benefit ANY database. I was talking about *specific* tuning of the
> SQL Server engine itself. Not much there that can be done...

Not that I'm a huge SQL Server fan.....but you can do many of the same things in SQL Server to tune the engine that you can do in Oracle. You can tune your engine by tuning the I/O, i.e. physical placement of datafiles. The engine can be tuned with statistics that the optimizer uses in creating an execution plan of the SQL statement. And you can even tune the engine by modifying initialization parameters. Granted, with Oracle you can do much, much more. But SQL Server does allow some of this as well.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"