Thank you for your guidance Brain.

Thanks you Jeff and everyone.

Hi Jeff,

I still didn't understand in what type of pages will the LOB data get stored ? apart from 8k data page are there any other type of pages to...

As per my understanding, LOB data will also get stored inside the page. However , if the row data is exceeding 8000 bytes, then the data is stored off the...

It's a POC server for 2017 upgrade. Waiting for a service pack to be released. I think only cumulative updates are available so far.

This database is a old database and...

• This reply was modified 4 years, 10 months ago by bobrooney.81.

Thanks for the clarification Grant & Mike.

A picture of a plan isn't a plan, all the good stuff is in the properties.

However, assuming that estimated plan is correct, and you're getting a clean index seek,...

Not much you can do, I'm afraid.  You either wait for the transaction to finish (in which case you may need to add more log space) or abort it...

• This reply was modified 5 years, 6 months ago by bobrooney.81.

A picture of a plan isn't a plan, all the good stuff is in the properties.

However, assuming that estimated plan is correct, and you're getting a clean index seek,...

I know that it won't seem like it should make any difference but try the following and see if it does...

UPDATE tt

set SQL_DETAIL='SELECT ROWID_OBJECT, HUB_STATE_IND, MDM_ID, SEQ_NM, MSP_END_CUST_NM, SEQ_TYP_CD,...

No Triggers. But its a Heap Tbl.

Hi John,

Thank you for the response. I haven't captured the wait type information One more thing is, the query finished its execution after 1 hr 45 mins approx.

My doubt was...