Good evening, party people! I finally have my new San Diego home base all set up and unpacked, so I took a champagne break to review your top-rated questions from https://pollgab.com/room/brento.
Here’s what we covered:
00:00 Introductions 00:27 Alex: Hi Brent. For a few hours we got a “Could not continue scan with NOLOCK due to data movement” error on a proc that used read uncommitted isolation (I know!). The errors stopped when the proc was recompiled. What are your thoughts on why the recompile stopped the error? Thanks. 02:15 No Longer a DBA: Hi Brent, recently accepted a