Just add /!X /!C after the DTS command.

DTSRun /~Z0x7078C2EC98.... /!X /!C

That will decrypt the string and copy if to the clipboard.

Then paste it somewhere and you will see something...

When you run SP2 against your PC, after a couple of screens, the list of things to upgrade comes up with checked or unchecked boxes. If you don't have that...

We have a couple of options where I work to give the developers access to production or near production data. First, we have a review login set up on production....

I would try the maxdop option (maximum degree of parallelism) on your select query and see if that helps. That limits the query to use a specific number of processors....

Cache hits may not increase just because you increased the amount of memory. Most of the issues with lower cache hits that I've seen are a result of other problems...