You say it happens on large datasets. Are you small ones getting thru? When ran thru the automated way.

Many ways you could approach this but I think you are right in starting with the front end to determine how the tables relate. Once you have this I would...

There is another topic here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=151303

where the persons states a join in the where is coming out faster than a true joined query.

However at worst case they should perform the...

Dude I am a geek but you have wwwwwwwwwwwwwaaaaaaaaaaaaaaaaaaaaaayyyyyyyyyyyyyyyy to much time on your hands.

As said in the previous, no. However what driver are you using to make the calls for notes and have you tested running the SQL Agent by starting the job...

No that sounds like dealing with specialized hardware and will need an application of some kind to intercept the data and forward to sql like was going on with the...

Just a thought but why not look into SQL Report Services might even be more economical than Crystal but has a lot of power.

Definently see if everything is occurring the same with Profiler, also take a look at the execution plan on each machine to see if something is happening different with the...

I would also suggest that if the data is slowly changing with few updates then those tasks may not buy you all that much but data that is quickly changing...

COuld be a number of things. Did you use the same connection for the workstatiosn and laptop or where the networks different? What other processes were running on each machine....

ALso don't let Crystal neccessarily do the joins and groupings sql for you as it will not optimize a whole lot in itself. Many times if the report is fairly...

Also has many more factors that impact performance than just numbers. Size of transaction, recovery model, IO subsytem, cpu utilization, memory, the list goes on.

Note the problem is you are doing * for the count which will be 1 per row. Instead do

SELECT

 Count(D.EMPLOYID) AS CountID,

 T.EmployID,

 T.EAcct_Num

FROM

 HFC.dbo.DD00100 D

RIGHT JOIN

 Epay_Transaction_Table T

ON

 D.EMPLOYID = T.EmployID

WHERE

 T.Enroll_Ind...

It could be something sutle in the way the query engine restated the query in JOIN terms.

Can you post the size of each table for me as I have altered...

It shouldn't create more rows (at least not that I have ever seen or can recall running across before). How are you determining rows in the index also?