After a pretty long search I have just found what I was looking for ...

It is :

DBCC MEMUSAGE (names,100) for ex shows up the first 100 objects in the cache...

You could eventually pin the table in cache (DBCC PINTABLE) but be sure first there'is enough RAM available for this... (all the advices above)

Virgil Rucsandescu

It could have sense sometimes... Using the Profiler that comes with the Management Console of SQL Server 2005 against a SQL Server 2000 server could give these results 😉

Virgil Rucsandescu

Please ... Maybe it was a stored procedure, I am not exactly sure ... but it has a parameter (whatever - DBCC or stored procedure) that means

something like "show me...

you should think about building a full-text index and using CONTAINS instead of LIKE ... 😉 (difference in perf should be huge... - speaking from experience)

1st: sorry, hierachical text would be a better explanation - I got it already but I read that I could get statistics info too with the other event...

2nd: I...

I'm trying to get the exec plan in xml format (remember, I'm on sql2k), times , nb of reads and so on (this is the first time trying this) ...

And...

Ofcourse it is .. otherwise I would be fired ... 🙂

this is definitely one step forward, but how could I get the exact syntax of the statement run against the db? (not just select , awaiting and son on ...)?...

I was a little misunderstood - func(A.something) is not an UDF ... just something like A.some_field = a_value or something like that, I know that UDF are not a very...

SELECT

ApplicantContactGrant.CompanyID, ApplicantContactGrant.ApplicantID, ApplicantContactGrant.GrantName,

ApplicantContactGrant.DtAdded, ApplicantContactGrant.StatusCD,

Applicant.OrgName,

ApplicantContactGrantDetails.Amount, ApplicantContactGrantDetails.IK2TotalAmount,

ApplicantContactGrantInKindP2.IKValue, ApplicantContactGrantInKindP2.IKDate,

ValidCurrency.Name

FROM ApplicantContactGrant

INNER JOIN Applicant

ON ApplicantContactGrant.CompanyID=Applicant.CompanyID AND ApplicantContactGrant.ClientID=Applicant.ClientID AND

ApplicantContactGrant.ApplicantID=Applicant.ApplicantID

LEFT OUTER JOIN ...

the query is an ad-hoc query, not a stored procedure.

same_fields is something like t1.f1, t2.f2, t3.f3, ..., t10.f10

(it doesn't contain * ... 🙂 and UNION solution is not...

Ooops , I'm using SQL Server 2000 :-((

Msg 512, Level 16, State 1, Line 1

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or...

I have checked already the indexes of the tables, the tables are linked properly and all the table joins are based on fields contained (all of them for all the...