Hi,

I hope the data you are brining home is not at least Confidential/Secret.

Quick question, what's the problem using one server for all databases, where you set Max DOP for example...

Be very careful about following such index hints (Brent Ozar refers to them as "Clippy", from the old MS Office days).  They are usually a good hint as to...

• This reply was modified 8 months ago by  Martass.
• This reply was modified 8 months ago by  Martass.

Ok thank you for the confirmation, unfortunately...

"

If you want advice on what will be good indexes you can start by using the "Database Engine Tuning Advisor" in SSMS, it is located under the Tools menu....

Hi Jonathan,

Thank you for the clarification. Seems to me that I am not understanding the purpose of indexes in this case.

I thought that indexes are used to find quicker the...

Hello,

May be I am doing something wrong, may be I am not understanding how the indexes are working, but the final statement does not read the indexes. Here is the...

BSEG is a heap - why don't you have a Clustered index on it?

and reason for not using any of the other indexes may also be related to not...

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 of...

Hi everyone,

Thank you for you really quick and useful answers.

I forgot to tell you the most important part, I need optimize the query and tables for this query, and the...