Reformated so that's easier on the eyes.

Can you post the actual execution plans (at least 1 loop)

There's a lot going on in this and it's not easy to...

Grant Fritchey (8/4/2011)

---

I see someone else mentioned it, Red Gate's SQL Virtual Restore allows you to "restore" a database backup. You can even restore log files to a point in...

I don't have a ready made script for that, hopefully someone else did (you might want to search the script section here).

This is where you need to start : http://msdn.microsoft.com/en-us/library/ms190325.aspx

That's my whole issue. Server's been online...

Please attach the actual execution plan in a new message (.sqlplan).

I never setup linked server to oracle. I'd start a new thread if I were you. You'll get better exposure andbetter chance for a good / quick answer.

Exactly my point :w00t:.

HTH, MadTester has brought in valid points. I live in an environement where index space is...

Assuming nothing is waiting on that spid to do something I think you can wait untill the next server recycle.

A restart should do it, but I don't know if there's another way.

What's the current wait info for that spid?

What was it doing before the kill, what is it waiting on now. How long had it been working on before the kill?

Both queries will be happy with index 2.

How long have they been working since the kill?

What were they doing before the kill and for how long.

What does this return (waiting info).

--Borrowed from the activity monitor

SELECT

...

Don't start a new thread. Continue with the one you have already. You can find it by hitting my posts middle top of the screen.

No replies here, follow...

😉

ALZDBA (8/3/2011)

---

e.g. one of the first optimisations i did by altering a svf to an itfv resulted in:

before: duration +/-4000ms

after: duration +/- 328ms

This was for a single query that was...