First of all :

Select ''' + @tablename + ''',Count(*) As Counter From ' + @tablename

Second of all :

Select O.name, MAX(I.RowCnt) as RowCnt from dbo.SysObjects O inner join...

When you post the ddl and sample data we'll be able to help you. Good luck until then.

"I had come to the same conclusions but type much much slower than he does. (Probably think slower as well but I am not going there)"

Don't sell yourself short, I...

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...