Unexpected Blocking during the Indexed View Creation
Here are the chronicles of my struggles to add a large Clustered index to a View without causing an outage.
Indexed View
2 posts
IS Lock in RCSI Enabled Database
I found an IS lock in a deadlock report on an RCSI database. That shouldn't be possible. Here's what caused it.