You may try to find it in Windows Event Logs ("Application"). It will show User.

Got it! thanks Gail!

when i just tried to kill the session again. it showed,

SPID 107: transaction rollback in progress. Estimated rollback completion: 0%. Estimated time remaining: 0 seconds.

thx for reminding.

I will not restart sql server for this. It looks like no other session as been affected by this session. however, the weird thing is that the session...

ok. and that's what i'm doing now. it has been 2 days...before i killed it, it had run for 18 hours...

Printed books at home and pdf at workplace.

Sorry, and yes, I meant with (nolock).

V

Hi, Guess what, it did count the uncommitted records...

I've done a test,

Step 1: run "select count(*) from table1;" -- return 3

Step 2: begin a transaction to insert 3 records into...

Thanks Chris. And sorry I forgot to mention that I've followed your first reply and compared the explains and they are identical. Then I checked the column on my 2...

2 index scans are unavoidable?

Thank you Gail & Chris for explain.

Just checked my tables and the "col1" on both table are non null. So it seems it's unavoidable.

Bhuvnesh (1/17/2013)

---

Place your (

SELECT a, b FROM KEY_TABLE kt JOIN......

UNION

SELECT a, b FROM KEY_TABLE kt JOIN......

UNION

SELECT a, b FROM KEY_TABLE kt JOIN......

) T0

code in temp table and add...

Bhuvnesh (1/16/2013)

---

sqlnes (1/16/2013)

---

It's weird, when I tried it today, it has back to the "correct" plan without set FORCEPLAN. it has been running fine now. I just wondering now would...

Thanks guys!

It's weird, when I tried it today, it has back to the "correct" plan without set FORCEPLAN. it has been running fine now.

I just wondering now would it...

Got it! Thanks!