We have a couple servers still running sql2000, we just upgraded one to SP4 from 8.00.2039, a simple query
select * from person_time pt
right join person_time_data ptd on pt.person_time_key=ptd.person_time_key
where pt.person_time_key is null
takes 37 seconds after the patch, we cloned the system to a VM prior to the upgrade and the same query takes 4 seconds there.
Any insight would be helpful. how a server pack can effect joins?..