Indexed View

Here are the chronicles of my struggles to add a large Clustered index to a View without causing an outage.

I was investigating a mysterious Intent Shared lock in a deadlock report. Especially confusing, since the database was using an Optimistic Concurrency.