>Yes... what does your disk storage look like?
The disk is a n/a Fiber attached SAN 600 GB.
I will have to see about requesting network admins to do some verifications.
>NOLOCK certainly would help, but it would not hurt to look at the isolationlevels as well. But only if it cannot be resolved by having faster disks.
Thanks