Altering schema of indexed view causes index to be dropped – And other limitations – SQL Server
Limitations of Indexed Views – SQL Server I have been caught out a few times by the limitations of indexed views. Often they are seen as the quick solutio...