Viewing 15 posts - 1 through 15 (of 134 total)
In Access, I would see that the DB size would keep increasing even after I deleted data. I had to shrink the database to get back to its true size. ...
May 1, 2022 at 9:29 pm
Here is an article you should review: https://qa.sqlservercentral.com/articles/managing-transaction-logs (also linked to in my signature).
If your database is in full recovery model - you *must* perform frequent log...
May 1, 2022 at 9:25 pm
Thank you both for your replies. I will review. Coding isn't my strength so it will take a bit of time to process the suggestions. Thank you again!!
April 22, 2022 at 4:55 am
Even with the columnstore thing, the original issue on this thread has never been solved. What made the old query suddenly perform so poorly when the database was moved...
April 12, 2022 at 5:51 am
instead of having all your tables as heap and with additional non clustered indexes (columnstore or not) try and make one of them a clustered columnstore (or a normal...
April 11, 2022 at 9:46 pm
another question...
the execution plan says to create a non-clustered index on main table with the suggested fields:
Missing INdex (Impact 41.8205): Create Nonclustered index [<Name of missing index, sysname,>] on dbo.MyDB...
April 11, 2022 at 5:35 am
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?
the query...
April 11, 2022 at 5:11 am
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 worked! ...
April 11, 2022 at 4:59 am
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
Viewing 15 posts - 1 through 15 (of 134 total)