I tried the index tuning wizard.
Thanks for all your efforts.
Just wondering how things were coming. I haven't heard anything yet.
Happy New Year!
I emailed the file - did you get a chance to look at it?
ok, i've got the trace. how do i get it to you guys.
ok, let me see what I can get for you - thanks again...
Whoops, I was gonna reply to the question about id'ing the query, etc. and left a quote by mistake.
I'm an old mainframer. I've done some Unix and...
I did, but maybe I didn't run it long enough or trace the right things because it didn't show any problems.
SQL Server standard edition
Microsoft Windows NT 5.0
NT Intel X86
OS memory 2175(MB)
Under parallelism, I changed to Use 1 processor.
It didn't help the transaction.
The "minimum query plan" is still set to 5. Should that be changed...
do i need to restart the server?
I tried the rebuild and it helped a tiny bit. Where do I check for the degree of parallel?
thanks, I'll try that
We have an application that takes 4 times longer to run in the production SQL 2000 environment than it did in the development SQL 7 environment....
Separate names with a comma.