Viewing 9 posts - 91 through 99 (of 99 total)
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
May 22, 2013 at 7:41 am
Try checking the References between the tables again... I am sure you are missing something there.
May 22, 2013 at 7:23 am
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...
May 22, 2013 at 7:10 am
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.
May 22, 2013 at 6:50 am
thanks Newbie. I removed nvarchar field(T.Name) from group by area. Now, the performance is good compare to previous one.
Be careful with the conclusions you draw from this because...
May 22, 2013 at 6:37 am
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)...
May 22, 2013 at 6:18 am
Try the below query..
FROM @mySampleTable s
OUTER APPLY (SELECT TOP 1 FROM @mySampleTable g WHERE s.CaseID = g.CaseID
May 22, 2013 at 5:17 am
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 22, 2013 at 5:05 am
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...
May 22, 2013 at 4:56 am