Is the engine smart enough...

GilaMonster (8/22/2011)

---

Unless there's major blocking/waits on the slow one.

But...

P.S. when something runs 10X slower than something else, the plan is NOT the same... or should not be the same.

You're telling your mechaninc that you have a problem with you car, without any more details and without letting if see the car or run any diagnostics.

Good luck fixing your...

can you at least post the actual execution plan?

When was the last time you updated the stats on those tables?

Roy Ernest (8/22/2011)

---

There is one problem with Autocreated statistics. It is rare but can happen and has happened in our environment.

Let us say we have a table with 6 columns...

No possible way to make that call without seeing the standard queries hitting that table, their execution plans and the % of each query type.

Thanks for the very detailed post. It's really helpful to helps us help you.

Now the only missing part is 1-2 sample date + required output.

Right now I don't understand...

sonythan (8/22/2011)

---

Hi thank you for your reply

The problem with div by billion is some of my company store has so little sales. Not even get a billion number.

But i just...

Grant Fritchey (8/22/2011)

---

I have...

Yes you...

Good thing it doesn't work.

The command you need to run is backup log. Not truncate log.

If you don't care about losing all the data between full backups change the...

Now keep in mind that I have a tone of tables with very little or no data. So this will get different results that 1 big table.

SELECT COUNT(*) FROM...

The real problem is the join hint.

I've never heard of <auto>-update stats causing problems. I'm not saying it's impossible, but on the very improbable side.

I type slower than I think.

ISNULL(Colname, '')

😀

If this was not a one time deal I would put a bunch of ors in the where to only update the rows that...