Viewing 9 posts - 16 through 24 (of 24 total)
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...
April 16, 2024 at 8:18 am
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...
April 2, 2024 at 1:02 pm
I would guess that it would give the same recommendation in your scenario of moving it to a local machine compressing the tables.
Ok thank you for the confirmation, unfortunately...
March 27, 2024 at 12:02 pm
"
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....
March 27, 2024 at 10:57 am
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...
March 20, 2024 at 9:02 am
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...
March 18, 2024 at 7:35 am
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...
March 15, 2024 at 11:26 am
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...
March 15, 2024 at 10:37 am
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...
March 15, 2024 at 6:12 am
Viewing 9 posts - 16 through 24 (of 24 total)