[Video] Office Hours in Port

Our cruise ship pulled into port in Victoria, Canada, so before we head out to the Butchart Gardens, let’s go through your top-voted questions from https://pollgab.com/room/brento.

Here’s what we covered:

• 00:00 Start
• 02:17 Janis: Hey Brent, Deleted million of rows from Azure SQL clustered columnstore ix. Want reclaim free space in shared elastic pool without long table blocking, but SHRINKDB and usp_IncrementalShrink does not help much. Help 🙂
• 03:35 Used-to-be-DBA: When you began your career, what were the IT job functions or titles that people were worried about disappearing? Why don’t people take the mindset of “always be learning’? I work with data, but I expect my actual job functions and title to change throughout my career.
• 03:47 Used-to-be-DBA: When you began your career, what were the IT job functions or titles that people were worried about disappearing? Why don’t people take the mindset of “always be learning’? I work with data, but I expect my actual job functions and title to change throughout my career.
• 06:21 Not 2019: Have you had any bad experiences with SQL Server 2022’s adaptive memory grants? I’ve twice needed to use emergency MAX_GRANT_PERCENT hints because a query that needs megabytes of memory started taking a quarter of my RAM.
• 07:37 ContestWinner: Hey Brent, when you give away bundles in your contests, is that yearly or lifetime access?
• 07:54 johnkurt: first thanks for helping us. we see some cmemthreads and we have already ctfp=50 and maxdop=8. A microsoft page suggest maxdop up to 16 in our case. What is yours experience with maxdop greater than 8 ?
• 10:13 Used-to-be-DBA: Hey Brent, LLMs are not deterministic. If users are using natural language to ask AI questions about data, then does that mean the query results are not deterministic? If I ask for month over month earnings, then will I always receive the same query result?
• 11:36 Blommetje: Do you ever tinker with things like Arduino, ESP32, HomeAssistent or iot things? To monitor pool temperature or toggle the driveway lights.
• 14:51 gserdijn: Regarding procedure sp_spaceused. Is there anything useful to say about the value of the ratio total_index_size divided by total_data_size? Any heuristics whether a database might be overindexed or underindexed? Might be only useful as a trend metric.