Viewing 15 posts - 15,781 through 15,795 (of 18,926 total)
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...
July 4, 2005 at 7:27 am
When you post the ddl and sample data we'll be able to help you. Good luck until then.
July 4, 2005 at 7:04 am
"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...
July 4, 2005 at 6:46 am
I have a pc at home... will probabely pop in once in a while
. But I have other plans for those...
July 4, 2005 at 6:44 am
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...
July 4, 2005 at 6:41 am
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...
July 4, 2005 at 6:16 am
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...
July 4, 2005 at 6:08 am
The question is Will you win??
The answer is no because I have no laptop.
July 3, 2005 at 9:32 pm
Please do not cross-post.
Finish the thread here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=131&messageid=196547
July 3, 2005 at 12:05 pm
Select master.candiid from master left outer join child on Master.candiid = Child.candiid where child.candiid is null
July 3, 2005 at 12:04 pm
You can replace the 'do nothing with DoEvents so that something gets executed. You might also want to replace the 5M with 5K
July 1, 2005 at 10:12 pm
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...
July 1, 2005 at 8:03 pm
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...
July 1, 2005 at 8:02 pm
Viewing 15 posts - 15,781 through 15,795 (of 18,926 total)