Want to ask your own questions or pick the ones I discuss? Head over to https://pollgab.com/room/brento to get involved. In the meantime, let’s hang out in the backyard, where Beni makes a special guest appearance.
Here’s what we covered:
00:00 Start 00:57 Old and Tired DBA: Should I convert all of my parameters to local variables in my stored procs? 02:21 MyTeaGotCold: Do you ever use hints like ASSUME_MIN_SELECTIVITY_FOR_FILTER_ESTIMATES or ASSUME_JOIN_PREDICATE_DEPENDS_ON_FILTERS? They’ve saved me a few times, but I think they’re not in most people’s toolbox. 03:42 emre: We have a problem with VMware snapshot creation: