I suggest that you post on a new thread.

People hardly monitor old threads like this one.

Restarting the server is never a good solution.

If the job gets stuck, you have to find what it is doing...

ChrisM@Work (10/23/2014)

Without DISTINCT,...

I'm sorry, this is a SQL Server forum.

Information on Oracle can be found on the Oracle forums.

Please define "hung". Does it last longer than you expect? It never ends?

Backup, Mirror and Snapshot will always contain all the data in the database and won't let you filter just the data of one customer.

Moreover, snapshots can only reside on the...

Unfortunately, OPENQUERY doesn't support dynamic parameters.

However, you could change your query to use EXEC...AT:

EXEC('

SELECT *

FROM MyTable

WHERE Field1 = ?' , 'A'

') AT ALinkedServer

You may get error "Server 'ALinkedServer' is not...

Stefan Krzywicki (10/22/2014)

Of course, regionalisms mean it could be called most anything.

For example: In most of the USA, a blended milk and ice cream drink is called a Milk Shake

In...

Extremely good point,...

For me this is a grill

And this is a barbecue

Am I wrong?

As far as the new CE is concerned, Kimberly Tripp blogged some days ago about options to adopt the new CE: http://www.sqlskills.com/blogs/kimberly/sqlskills-procs-analyze-data-skew-create-filtered-statistics/

Before migrating to the new server, I would bechmark...

Your query can be rewritten like this:

SELECT A.activityCode

,A.ActivityName + ISNULL(A.description, '') AS ActivityName

,A.displayOrder

,A.activityStartDate

FROM Activities AS A

LEFT JOIN Activities...

We don't know how your tables or data look like.

See the first article linked in my signature line and discover how to post effectively and get replies faster.

Moreover, NOLOCK...

You're welcome

What do wait stats look like compared to the ones you had on the old server?