Can you run your test as the only active user of the server?  If so, try running sp_mointor before and after your test.

That could then perhaps point you in the...

If you have 10,000 entries within the QueryLog table; then could you compare the differences between the StartTime column between one execution and the next to determine the milliseconds between...

I just realized from looking at your other post, that you're using Analysis Services 2000, which does report only seconds within the duration column.

Rather than have two discussions going for...

Sorry, my mistake, I wasn't paying close enough attention to your question.

From my understanding of Analysis Services 2005, the Duration column within the Query Log table is in milliseconds.

http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/config_ssas_querylog.mspx

If I understand this correctly, when an insert occurs, you want to:

1.  Check for the existince of the mananager;

2.  If the manager is not already listed as an employee, then...

KC,

It appears that you can have multiple DischrgSessID values for one Waste Discharge, but then you do not include this aspect within your grouping.

Are you not wanting to differentiate between...

When you created your usage based aggregations, did you use specific criteria (date rage of cube use, specific users, execution frequency, storage mode, or response time, specific queries) ?

Will the...

Have you tried using this and running the query manually:

set statistics time on

You're welcome...

One thing that did concern me about your original query is that the I.InvoiceDate is likely a Datetime, and so the @EndDate you're using may not include everything you...

Have you tried simplifying it like this?

SELECT I.ItemNo, I.ItemDescription AS ItemDesc, SUM(I.QTYPackSizeDescription) ItemMovement

FROM Invoices I, StoreGroupMembers S

WHERE I.StoreKey = S.StoreKey

AND S.StoreGroupID = @StoreGroupID

AND I.InvoiceDate BETWEEN @StartDate AND @EndDate

GROUP BY I.ItemNo,...

How many rows are in the table?

How many distinct values are in the table for each of these columns within the index?

How many indexes are on the table and what...

The in and not in clauses are being turned into join/outer join clauses by the optimizer:

select count(*)

from mainestimatedetails d, mainjobdetails j

where d.id *= j.estimateid

and j.estimateid is null

Unfortunately, for SQL 2000...