I had the same thing happen on a Dell server. The mainboard was replaced and some of my jobs took twice as long to complete. Bios was not set on...

Sorry for not getting back with you all sooner.

I guess what I really need is a view that I call and have the join in that view.

I am even having...

:w00t:I'm a SQL developer that keeps very busy most of the time.

I don't think I would ever come strait out and tell a forum that I am to busy to...

I have sql 7 dev. edition and also have never seen both processors used...

All settings have both processors turned on.

If anybody has the answer I would shure appreciate it..

Have wanted...

Thank you Kathi

Problem solved...

Bob