Viewing 15 posts - 241 through 255 (of 376 total)
Can I change it? I would like it to grow as the data gets larger...not start off so big and then the data size doesn't justify the db size.
January 30, 2023 at 2:54 am
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://www.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 backups (at...
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
Viewing 15 posts - 241 through 255 (of 376 total)