>I have a machine in our office Win Nt SP4 with Sql server 7.0.
>Single Processor
>
>Clients Site
>Server with dual processors.
>
>I have a Query that takes 7 minuts at my office but the same query takes 51 minutes at clients end.
>
>Under the execution plan it shows the server using parallelism and at my office it doesn't use parallelism.
>
>should i increase the time to the maximum for parallelism for this one stored procedure and then chnage it back to the default at the end of procedure...
>
>or can any one help with making it run faster.
>
>TIA
>Shawn

Shawn,

Check out MSKB #Q247500

Direct link:

http://support.microsoft.com/support/kb/articles/Q247/5/00.ASP?LNG=ENG&SA=ALLKB&FR=0