_taz_ (6/15/2010)

---

the way it was, it was returning all the notes (for the one client I tried) doing it your way only returned the last entry and put the userid...

I just saw that Microsoft actually decided that this problem was not only regarded as a bug but that they even considered it worth fixing.

See : https://connect.microsoft.com/SQLServer/feedback/details/553303/constant-folding-can-cause-compile-time-error

So it seems that...

moosamca (6/14/2010)

---

HI All,

The attached query is running for more than 5 min and ending up with the below mentioned following error . I ran the query execution plan and found...

SQLSeTTeR (6/14/2010)

---

Its inserting from the same table its selecting from, but it's truncating data coming from the same column. What am I missing?

DECLARE @To int, @From int, @LogonID...

I think that you have to accept that in this case it is very difficult for the server to get good estimates of the number of rows needed.

When you use...

I see.

I never understood what you meant with your "Version"

I now understand that the number of rows you were talking about originally should be multiplied by the number of versions.

I...

gtschech (6/15/2010)

---

Thankx for your responses.

I have seen the bad statistics you pointed me on.

Until that I believed I had updated the statistics; between every load into the database and processing...

The problem here seems to be caused by bad statistics.

The seek from ZuoPositionAggregation has estimated rows = 18, but actual rows=113566

The seek from ZouRisikoFactorAggregation has estimated rows=1.8 M but actual...

First I think we should make it clear why this query is so hard for the SQL server.

The original query looks like this:

SELECT *

FROM EffectiveItems

WHERE 982827279 between LOW and HIGH

...

Any news about this ?

I am curious 😎

ss-457805 (5/24/2010)

---

Everytime a status changes it writes a record in the statushistory which then gets audited and is written in productionaudit table.

So for instance the status was 2 between...

ss-457805 (5/24/2010)

---

The question is what you want to do when there are multiple entries in the statushistory that matches the assetid. Whatever you do you must make sure that you...

I tested this on SQL 2008. I got exactly the same behavior as the OP.

Maybe there is a difference here between 2005 and 2008 ?

ss-457805 (5/21/2010)

---

p.cellAssetDesc ,

sh.auditid as lastStatusChangeAuditId

INTO dbo.New2

FROM dbo.productionAudit p

Left...

Give me a break. 😉

Dont you have weekends...