[Video] Office Hours: Just Three Questions
Sometimes y’all post questions at https://pollgab.com/room/brento that require extended answers. Today, I’m hitting just 3 questions:
Here’s what we covered:
- 00:00 Start
- 00:44 MyTeaGotCold: If storage is no issue, do I need to worry about the size of Query Store? It’s going to hit 10% of the size of my largest database. I have no interest in changing QUERY_CAPTURE_MODE away from ALL or my retention period.
- 04:12 DB-Ay?: For a high activity table, is it worth updating stats at a higher percentage just for auto-update to resample at a lower rate within an hour? I’m not able to persist the value and auto-update must remain enabled. I think my only option is to exclude it from the custom stats job.
- 08:39 David E: I took over for an idiot who setup every database to have 4 transaction Log files per database. I have tried everything I know to remove the files, but it errors out everytime. Never had to deal with before in my career. I have tried some things with no success.
3 Comments. Leave new
Harsh on the third question answer. Kind of deserved though!
That 3rd answer made my day. I get that a lot.
Something is not working, no error message or any detail. After numerous back and forth, I figure out what is not working.
I wish to publicly state that the David in the 3rd question is not me! (Although I have done plenty of stupid stuff in my time.)