Try running below query, will return you tables list with last statistic updated date and rows updated later on, these tables requires a statistics update with FullScan

SELECT OBJECT_NAME(id),name,STATS_DATE(id, indid),rowmodctr

FROM sys.sysindexes

WHERE...

Try checking the References between the tables again... I am sure you are missing something there.

The case is with table f. alias so if it is not firing then some value in f table is missing and not fulfilling, and dont see any problem with...

jhager,

If the EXEC are calling inside a Stored Procedure then this may be because of Paramete r Sniffing, alter the stored procedure with 'WITH RECOMPILE' and try once.

ChrisM@Work (5/22/2013)

Be careful with the conclusions you draw from this because...

Sorry.. I didnt read the post completely, so here is the modified query,

SET STATISTICS PROFILE ON

SELECT aa.* FROM @mySampleTable aa

INNER JOIN (SELECT a.CaseId, a.latestUpd FROM (SELECT CASEID, COUNT(*) CCnt, MAX(CreatedDate)...

Try the below query..

SELECT *

FROM @mySampleTable s

OUTER APPLY (SELECT TOP 1 FROM @mySampleTable g WHERE s.CaseID = g.CaseID

...

Difficult to comment without table / plan info.

One suggestion Skipping char/varchar columns from groupby clause gives you better query performance, for the final output result where you need Name in...

May be some issue with your network or firewall blocking server login which inturn giving an error,

and one more thing -S switch will not work without instance name you...