Well, I get the feeling that dropping the indexes isn't going to do much. SQL server seems to be adding indexes automatically when it feels it needs to. For example this one, _WA_Sys_clientid_3D5E1FD2 which I did not create.<br><br>I seems to still be adding records at a rate of 200 per second which I guess I can't complain about.<br><br>As for clustering, the administrator feels that clustering will just kill the server. It would have to re-order at least 1 gig of data. Thats 1 gig of data that will be changing about one or twice a week (ie, whacking half a million records and adding another half million, sometimes more).<br><br>I think in the near future we'll be getting a raid array and probably more RAM. I'd like to see the bosses go for a sparc with Oracle. I don't think I'm extremely impressed with SQL server.<br><br>-Clive