Learn T SQL With Erik: Indexed View Serializable Locking

Apologies for the low audio in this video â€" I was testing a new microphone setup that didn’t work out. Should be back to normal volume in future videos. In this video, I delve into the intricacies of IndexView maintenance in SQL Server, specifically focusing on how multiple tables within an IndexView can lead to complex locking scenarios and isolation level promotions. Using the StackOverflow 2013 database as a case study, I demonstrate how updates to one table can inadvertently block operations on another, highlighting the importance of maintaining referential integrity through careful IndexView design. I also share some useful trace flags that reveal internal hints applied by SQL Server during index view maintenance, emphasizing the caution required when working with multi-table IndexViews. If you're interested in diving deeper into SQL Server performance training or want to support this channel, you can find a coupon code and my SQL Server performance monitoring tool linked in the video description below. CHAPTERS 00:00:00 - Introduction to Index Views and Blocking Issues 00:03:45 - Isolation Level Promotion to Serializable 00:06:51 - Blocking Analysis with SP_WHOISACTIVE 00:09:28 - Trace Flags for Detailed Locking Information 00:11:56 - Summary and Next Video Preview