There’s a secret theme to the questions I hand-picked from the queue at https://pollgab.com/room/brento. Normally I just take the top-voted ones, but today, see if you can spot the thing they all have in common:
Here’s what we covered:
00:00 Start 01:51 Tivan: Hi Brent, I’m facing a deadlock in MS SQL Server with “ORDER BY DESC” on a primary key (clustered index) during a read, conflicting with an insert on the same table. Is this related to descending scans? I couldn’t find a clear explanation. Could you share some thoughts? Thanks! 03:19 ddev: Sometimes