sorry here is sample data from concatenation

Nov 1 2010 1:29PM \ Nov 1 2010 11:13AM

Nov 9 2010 8:23AM \ Nov 11 2010 8:46AM

Nov 11...

Have to shink lack of space, trying to see what is wrong, this issue just popped up,

here they are

Here it is, I get the plan look but this is more telling

for the left outer join

Table 'cms_PatientStaging'. Scan count 34, logical reads 842, physical reads 0, read-ahead reads 0,...

Interesting, tried that the left outer join was faster and more efficient

I went from not in to left outer join, went from 87 seconds to 2 seconds

WEEEEEEEEHHHHHHHHHHHHHHHHHHHHHEEEEEEEEEEEEEEE

I plead some ignorance in trying to get not exists to work the syntax below returns and error

SELECT patid + facid

FROM pharm.dbo.cms_PatientStaging

WHERE...

Is an indexed view allowed without the schemabinding?

Just as any FYI, tested going from a sql 2008 box with one cpu, and 6 gig of RAM, still ran fast as compared to the other way, I beleive...

No but still pretty close, several minutes verus seconds is large

new cpu on 2008, more memory on 2005

There is actually more data on the sql 2005 side than on the 2008

But why when the query is run on the 2008 server the query back to the data on the sql 2005 server should still be slow. It isn't, no...

Good point for now I am running it under same account when it works and when it fails

All previous servers I setup used service account "A" for the SQl Server Services. This account also had an exchange account and has always worked. The new server...