I have an older Dell boxen with 2000 SVR SP4 with SQL 2000 SP4 Our app is getting slower as it ages and the mainboard cannot take more than 1GIG of ram. Without getting new hardware, Id like to use this time to tune the DB before we spend $$ on an upgrade. When I let memory go dynamic, it eats into all...

I have 2 questions 1) One big index performs better then 2 small indexes or the opposite? 2) I have table with 17242772 rows and I have index1 and index2 on that table, index1 has 14 columns and index2 has 3 columns. Developer created a new report in crystal it takes 2:47 min. I analyze the query through...

The stats seem to be the same. The restored db is only a day or so old. The stats get updated on production every morning and the indexes are rebuilt once a week. Our usual weekly reindex is done with a variation on the sp by T.Pullen with the scan density threshold set to 85 http://www.sql-server-performance...