We have a sql server2000 database designed by the vendor. No FK. No PK. We have lots of indexes..some are unique indexes... They told us to do this to boost performance: 1.Set the memory property (very important). Select the SQL server , right click, click start up properties, type in â€“g512 and press ADD. 2.From the same right click as above, select the processor tab, click â€œBoost SQL Server Priority on Windowsâ€ 3.Change logging from full to simple, remove old logging files if possible. 4.Keep unused disk space at 25% 5.Use SETRANGE commands, get rid of all SETLL, READ, CHAIN. --- I couldnt find "setrannge" command in BOL. Not sure what they mean by #5. #4: is that because of the back-up logs?? Should we remove logging files ( do they mean the transaction logs and stuff)? #3: is that a good idea for a production environment? #1 and 2: what is that "-g512"? is it ok to click the "boost" option? --- I think the problem is how the database is designed that's making it perform poorly. ANy thoughts?