[Video] Office Hours on Mount Charleston

For this episode, I’m up in the mountains just outside Vegas, enjoying the nice cool temperatures, spending the weekend at Mount Charleston. Let’s go through your top-voted questions from https://pollgab.com/room/brento.

Here’s what we discussed:

• 00:00 Start
• 01:41 youAskedForAProblemThatWouldBenefitFromLargerTable: Problem:Table is 100% larger than ideal. Page splits decrease page density to 51% after adding just 1% new records following rebuild with 100% filfactor. Fix:Making table 10% larger w/ FF 90% allows adding 8% new records without decreasing page density or enlarging table further.
• 04:59 AndrewG: (I am SaaS support) I see a lot of DBAs utilizing Query Store. Is there any reason I should use this instead of the first responder kit?
• 05:55 chris: Hi Brent! You’ve shared the RSS feed you use and it’s a very lengthy list. Do you manage to keep up with the entire feed?
• 07:30 Jersey: When designing an index that uses included columns, is there a “sweet spot” for the number of columns included in the INCLUDE clause, or does it primarily depend on the query workload and performance requirements?
• 08:22 PursuitOfExcellenceDBA: Hello Brent. Being a SQL guru yourself, just curious since you always refer others for their area of expertise. Have you ever reached out to Paul Randall or others and/or vice versa to solve a complicated SQL server issue that took you to finish line faster?
• 10:47 AlwaysLearningDBA: I have daily index maintenance job per your blog & weekly reindexing job.DB size is around 4TB (will keep increasing). Weekly index maintenance is running over 18 hours.How do I run Ola’s job in parallel for multiple indexes at a time? Looking for a scalable solution. Thank you.