Jack,

You could be right but when I checked the Options page for the DB it has Auto Update Stats and Auto Create Stats checked.

As I am not a DBA but...

Thanks guys for the replies.

We just bought a new machine which is going to act as a server. The old/current server is basically knackered and is so slow and is...