I have a pc at home... will probabely pop in once in a while . But I have other plans for those...

You didn't rule out the cached data and the compiled plans. When doing performance testing you must always ignore the first 1-3 calls to make sure that the data...

Maybe the statement didn't return the same amount of data or the data was cached for the 2nd execution. Maybe there was less network traffic. It could also...

No chance .

And you say this didn't work???

Select master.candiid from master left outer join child on Master.candiid = Child.candiid where child.candiid is null

Did you actually change the table names and columns names...

The question is Will you win??

The answer is no because I have no laptop.

Please do not cross-post.

Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=196547

Select master.candiid from master left outer join child on Master.candiid = Child.candiid where child.candiid is null

You can replace the 'do nothing with DoEvents so that something gets executed. You might also want to replace the 5M with 5K

Btw it's hard to stay away from here, addictive as it his. Also the fact that I have 50 to 100 emails in the morning when I first check...

Hmm I saw that post yesterday. I have to agree that he often crushes newbies when they post "wrong" questions in some unperfect way. However I have to...

Is this running on a 386???

Is there a trigger in the table. Are there any indexes on those tables?

Just curious... what did Noeld do today? It's not mentioned in the thread (unless I missed it, again ).

Finally a thread started from you... maybe next time you'll have to courage to ask a question (now I understand more why you're afraid).

Congrats on the thread.

yeah yeah I'm really...