We collect these statistics on a weekly basis. This way we persist runtime history for all monitored instances.

This comes in handy when provisioning for growth or planning migrations.

Devs and...

If you don't have all the columns that are included in the query in the index then SQL Server will have to read the index then go off to the...

Apart from saving space it is unlikely that rebuilding or reorganising the index will improve the performance of anything, in fact it might make it worse.

It sounds like the entire...

I am surprised that no one else answered the original question - and this just evolved into using temp tables and trying to solve the performance issue using a...

duplicate

• This reply was modified 1 year, 5 months ago by Jonathan AC Roberts.

I see many people that site things like a lack of training at work, etc, etc.

Tell me... if you have a degree, who paid for it?  How did you...

One more thing...

The create table and create index code was created before any rows were added to the temp tables.  Not sure why the run time grew like that.  ...

Hello,

I have found the problem, in my indexes i forgot XKRES table I missed that there is difference: XHRES and XKRES.

After preparing the indexes now uses all...

I am getting an error

Msg 468, Level 16, State 9, Procedure dbo.WIP_Query_V2, Line 462 [Batch Start Line 2]
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS"...

You need to remove the drop existing bit, as there is no existing index on a new table.

The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

One of the big advantages...

The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

One of the big advantages of putting...

The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

One of the big advantages of putting you results...

The optimiser should be able to simplify the query to remove the nesting so it might not make much difference.

One of the big advantages of putting you results into a...

You can simplify the query to this:

SELECT COUNT(*)
  FROM BSEG I
  LEFT JOIN BKPF H 
         ON...

• This reply was modified 1 year, 5 months ago by Jonathan AC Roberts.