Yep, most definitely SQL Server Linked Servers.

sp_linkedServers only shows me the servers linked from this instance, what i'd like to know are servers linked to this instance.

I've been looking at this for a few days now and I can't find anything to indicate that the MSDN media is in anyway identifiable post install. I believe that...

I think you're right. The more I read into this area the more it seems that the actual installation media/licence doesn't matter so long as the safe has enough legit...

Not so 'users' but developers who login from their applications to run DML statements.

We also use various groups for specific database permissions....

To those guys using AD groups, do you find that you have many groups mapped to logins e.g. many logins, or do you end up with only a few logins...

Thank you for your help and for the insight on picking the correct fields for new indexes. (thinking of old proverb about fishing and eating)

I like learning and hope that...

The first suggested index made little to no difference (probably why you edited the post!) and so I removed from my DB after testing.

The second suggested index halved the running...

ChrisM@Work (8/12/2013)

---

It is referenced:

CASE -- All std time captured on Move*, as this is where quantity is recorded

-- where Move trans types don't exist, qty is recorded on other trans...

ChrisM@Work (8/12/2013)

---

This, I think, would make a reasonable test query:

SELECT

jt.job,jt.suffix, jt.oper_num, jt.trans_num, jt.emp_num,

x.oper_num, x.trans_num, x.emp_num,

jt2.trans_num

FROM jobtran jt (NOLOCK)

OUTER APPLY (

SELECT TOP 1

jtx.emp_num, jtx.oper_num, jtx.trans_num

FROM jobtran jtx(NOLOCK)

WHERE jtx.job...

ChrisM@Work (8/12/2013)

---

I'd focus on the one table for now, which gives you this query:

SELECT

jt.trans_num,

emp_num = CASE

WHEN jt.emp_num IS NOT NULL

THEN jt.emp_num

ELSE

(SELECT TOP 1

jtx.emp_num

FROM jobtran jtx(NOLOCK)

WHERE jtx.job = jt.job

ANDjtx.suffix...

Don't know where my last post went so I apologise if this is posted twice.

I've attached a set of INSERTS for the jobtran table representing some doctored data. I hope...

Here's some doctored INSERTS to populate the jobtran table. It covers two jobs which I think is sufficient for analysing the problem. Is this suitable?

Here's the full statement:

SELECTjt.trans_num,

CASE

WHEN jt.emp_num IS NOT NULL

THEN jt.emp_num

ELSE

(SELECT TOP 1 jtx.emp_num

FROM jobtran jtx(NOLOCK)

WHERE jtx.job = jt.job

ANDjtx.suffix = jt.suffix

AND jtx.oper_num >= jt.oper_num

ANDjtx.emp_num IS NOT NULL

AND jtx.trans_num <...

The main query (from which this was the identified 'slow' bit) uses; emp_num, trans_type, a_hrs, qty_moved, wc and CreateDate in the returned fields; job, suffix, wc, oper_num and trans_num in...