Viewing 15 posts - 166 through 180 (of 290 total)
while looking into it - was there a reason for you to build a heap with columnstore indexes instead of making one of them a clustered columnstore index?
This is...
April 11, 2022 at 4:12 am
duplicate post
April 11, 2022 at 4:11 am
what is the compatibility mode of the database? - never mind - its 150.
Before trying anything else do a rebuild of the columnstore indexes on the tables used on...
April 10, 2022 at 9:17 pm
use https://www.sentryone.com/plan-explorer - it has a option to anonymize the plan so all object names/columns get replaced with "object1, object2" and so on.
and put it on https://www.brentozar.com/pastetheplan/...
April 10, 2022 at 8:47 pm
Cost Threshold for Parallelism = 5
Max Degree of Parallelism = 12
Are these values correct?
Definitely not for the first one. Bump that up to at least...
April 10, 2022 at 7:20 pm
I have a copy of the execution plan. It contains my query so I do not want to share that publicly. Is there a way to share the performance items...
April 10, 2022 at 2:19 am
The indexes will come along. Since they are part of the db, they get restored with it.
Good to hear
thanks for that!
April 8, 2022 at 9:33 pm
What happens to indexes when a database is restored from an old machine into a new machine? Do they transfer over or do I have re-do them?
April 8, 2022 at 8:57 pm
Cost Threshold for Parallelism = 5
Max Degree of Parallelism = 12
Are these values correct?
Definitely not for the first one. Bump that up to at least 40:
EXEC sys.sp_configure 'cost...
April 8, 2022 at 5:44 pm
Do you know how to get execution plans? Do you know how to interpret them?
You can generate an execution plan in SSMS if you click the "Include Actual Execution...
April 8, 2022 at 4:51 pm
In SSMS, you can right click on the server & select properties, then select Memory. You should set memory to something lower than total server memory so that sufficient...
April 8, 2022 at 4:49 pm
Statistics are what the query optimizer uses to choose an execution plan.They contain statistical information about the distribution of values. The Query Optimizer uses these statistics to estimate...
April 8, 2022 at 4:46 pm
What edition of SQL Server? Hopefully not Express, as it can't take advantage of all that horsepower.
Compare actual execution plans.
You might try updating statistics on the new computer.
You have...
April 8, 2022 at 3:21 pm
What edition of SQL Server? Hopefully not Express, as it can't take advantage of all that horsepower.
Compare actual execution plans.
You might try updating statistics on the new computer.
You have...
April 8, 2022 at 3:07 pm
Same version of SQL Server on both machines?
Yes
Both are running SS2019. The version for SSMS is slighly different.
the values produced by both the queries look the same.
it is almost...
April 8, 2022 at 2:29 pm
Viewing 15 posts - 166 through 180 (of 290 total)