I have a SQL 2000 Server where all the databases have been set to autogrow and autoshrink. I am trying to eek every last drop of performance out of the box so I want to change the databases and logs to a fixed size.
Can anyone help me with the procedure to do this? I have plenty of disk space, OS sits on a RAID1, Logs sit on a RAID1 and the DB's sit on a RAID10. The app was coded so long ago that it is impossilbe to upgrade it over to 2005, 2008 or 20012.