Painful performance - SQL 2000 Comparison

HillsmanHillsman Posts: 3
One of our SQL 2000 Servers was replaced over the weekend - I wasn't involved in the replacement, though as far as I was aware, the movement of SQL databases was a little unorthodox - The system databases were overwritten with copies from the original server; all other databases were then picked up once the database service was restarted (I would've used scripts to first backup, then restore all databases)

Anyway, since this process was completed, any comparison against a database on this server either takes 45+ mins or doesn't finish at all (database is about 115MB - largest table stores 150k rows)

Any ideas how I can speed this up?

Many thanks,



Sign In or Register to comment.