It's hard to tell exactly what's happening with incomplete information. Can you post the .sqlplan execution plans for both queries?

Also, check for other statements before these that might be placing other locks on the system.

One point to keep in mind, in most circumstances partitioning is not a performance enhancer, but rather a data management enhancer. Performance is frequently degraded somewhat by partitioning. In some...

Primarily, is the business ready to pay for an upgrade?

Assuming they are, I'm with the last post, Run the Upgrade Advisor first and address any issues it raises. After that....

Andy Hyslop (5/1/2012)

At +12K points you must know the points system inside...

If you can access the server, what's the status of the "stuck" process? Is it waiting on something? Check sys.dm_exec_requests to see what it's doing. Also, everything is part of...

Always, always, hit the documentation on MSDN. That's always the first resource, not posts to forums.

Yeah, Microsoft does. Follow the documentation available on MSDN.

Yep. A point per post. Varying points for the Question of the Day. So this is +1.

Compression is about the only way you can put X+5 into a space for X. It's that simple.

You disabled indexes at the same time as the index defrag program was running and you started the copy anyway? All at the same time? Yeah, you're blocking on different...

Sounds like an open transaction. Possibly a bad piece of code that opened a transaction but then left it open. Or, maybe an error on the server that resulted in...

The error seems pretty clear. Something changed. Is the table being referenced another view or a user defined function?

I would still be running a full backup on your system on a regular basis and having the log backups kept too. Rememeber, mirroring is an availability and DR option,...

Looking at the execution plan, you're returning 20k rows from the spatial index and then filtering that down to three values. Performance is going to stink. You need a better...