Holly "/*& )(* /"*(/& "!*(/&"!) ? / "*/& " that's so cool! :w00t:

How many runs did you do? Could be just from regenerating the plan and caching the data... 6 sec on the 1st run is not really bad news......

There's not performance probleme because there are too much stats but because they are OUT OF DATE.

have you tried running the update stats AFTER the insert?

tfeuz (6/3/2011)

---

The 2 table you refer to have only 1 row in them ---

The 80K of invoices is in the rb_invoicestoprocess table --- this is the list of items that...

sqlnaive (6/3/2011)

---

If you check DBCC SHOW_STATISTICS for any clustered index or nun clustered index of a table, you'll see data sampling for only first column of the index [If an...

I haven't read the whole thread, I just skimmed at the exec plan.

RB_Rule

RB_RulePeriod

The stats seem way off. expected rows is 1 vs 80K for actual.

You also get a timeout...

sqlnaive (6/3/2011)

---

Great knowledge feast on statistics these days. I was checking that statistics on any index maintains informaiton based on the first column of the index only. Now if our...

checkpoint??? How the heck did you come up with that one?

Checkout the output clause available both in insert and update.

I'd use distinct over ignore dup keys... I want to see what's going on!

If it were me I'd be to the point of calling PSS.

I've hit that very same bug back in the day and outside changing the dateformat at connection creation time...

Should be in sysindexes or sysstats... not sure.

You can go in the master db and check the source code for sp_updatestats I know it uses that column in...

I C.

Auto upstats on means that stats are automatically updated. If you check async it just means that the server won't wait for the stats to build the plan...

jennigirl (6/2/2011)

---

Ok. So I am in the right place and found the error:

"failed with the following error: "Online index operation cannot be performed for index 'HQ_SQL_PK' because the index...

Happens all the time :hehe:!

Source-NH (6/2/2011)

---

It sounds like your connection is picking up the US language instead of the Windows settings, which is the normal behavior. To change the settings for default language for...