yep, that should solve it.

First of all thank you all for your replies.

Michaela, that's is what I did, I created the indexes using the Index Wizard (in SQL 2000 as currently the db is...

All the tables have clustered indexes on the Primary key.

The heaviest transaction we have is a heavy select statement loop on a view and this view gets data from the...

Thanks Ahamd for your reply.

All the tables have clustered indexes on the Primary key.

The heaviest transaction we have is a heavy select statement loop on a view and...

Hi. I will be migrating from 2000 to 2005 soon. I did some testing but had to use the sp_change_users_login to solve login problems. In the coming days I...