by the way -

FCB stands for File Control Block, the physical file structure used

by SQL to write in and read data from the storage.

i've had these before...

http://support.microsoft.com/default.aspx?scid=kb;en-us;815183

the error Could not open FCB for invalid file ID %d in database '%.*ls'. is know to cause data corruption, thread errors and runtime errors

are there different service pack versions...

it would be easier if you put in the post the names of the 2 files so we can see the difference

there's a whole list of "non-batch breaking" errors listed on the microsoft site - most of them are pretty unusual - but some are quite alarming (such as foreign key...

i just found a whole bunch of other sites where this is a known issue by googling Jet 4.0 first rows

the actual number of sample rows is 8

more info as...

i had this problem before - have a look in the registry under the Jet 4.0 engine settings and there is a registry value that is used to "automatically determine"...

here is the link

http://www.youtube.com/watch?v=U_Kle3gKaHc

check your wait stats and see what the bottleneck is

if you haven't already then go on youtube and look up brent ozar's wait stats video which will explain how to...

you might want to check this slightly differently...... haven't...

to be clear - do you have an index on sourceid in t1?

it might be wise to take a snapshot of the query plan and post it up here

david.alcock (4/25/2012)

---

Just wanted to ask, if a log file has got too big and then subsequently a log backup has been taken, the recovery mode switched to simple but the...

csarsonas (4/25/2012)

---

@michael-2, sir you're right... i didn't able to put indexes in DRSummTemp table (this is just an extension table handling current records). The original table contains nulls and...

also is DRID a foreign key? - it looks like it to me - why is it nullable? is there a foreign key constraint on it? - i'd definatly look...

no indexes on drsumtemp then ? - you said 600k rows.... i'm guessing the correct indexes will make a difference

sean's solution proboably performs better than mine