We purchased a new 2GHz dual processor server to handle some large datasets (10 off 2 million records). Initially we had problems importing all tables into a single filegroup and needed to create a secondary filegroup. This was not required on our old machine. That done, we are now trying to run queries on tables with about 2 million records. Generally run fine, but we have timeout problems on complex queries, that run OK without a WHERE clause, but timeout when one is added. I created yet another filegroup and set that to default and can get one of the tables with just a single 'where like' clause, but no more without getting the timeout. Any ideas?