Hi,

For the beginning maybe you should check what is hapenning with that process.

You have plenty of solutions for that (activity monitor,DMV,etc.).

My advice:

--Run job again.

-- use...

Gila sorry for late response.

Problem was resolved. Only thing that we did was that we wait rollback/rollfoward process to finish 🙂

p.s

Excellent post!

Thanks for the answer.

The result is not really improtant because I was just checking in where is my load.

I got strange results becasue index which optimizer decide to...

" It's not the optimiser choosing when to update the stats, it's that the optimiser needs them and they are invalid. " - that was I ment when I said...

You don't need to reorganize and rebuild indexes in one maintenance plan (remove reorganize).

If you perform rebuild then you don't need to update statistics because rebuild also update statistics....

Yes, that is correct by the books but...

Optimizer will decide when to update statistics (seek operation good example)

You can try this.

-- create simple table

create table test_stats (ID int...

Auto update statistics fire when collumn change 10% of rows on tables larger then app 500 rows.

Is it possible in your situation?

Best regards,

Unfortunely I must agree with you 🙁

I understand you.

Yes I tried to rename db, I also tried to rename it with hexa editor.

It seems that Microsoft put some flag and that is the solution how...

Sorry, don't be angry to me.

I am preparing course and I wan't to be sure that Microsoft didn't change one thing in SQL SERVER 2008.

That is the reason...

Of course that I don't touch orginal resource DB 🙂

Right now it is not important what I am trying to do.

Hi,

Yes it is possible that hardware be the reason for different execution plan (parralelism is good example)

My opinion is that optimizer decide on different plan because he need to spill...

Hi,

This query was return only zeroes.

No I didn't saw anything in the log files which I could correlate with this strange behavior.

I tried to restart server but after start...

I know that (please see my first post again)

No it is not possible.

SPID 23 (background process) is blocked by -3 process. I don't know what is -3 but I know that 23 is trying to recover one...