SentryOne Team Blog (blogs.sentryone.com)

Tag : indexed views

Paul White : An Indexed View Bug with Scalar Aggregates

Paul White (@SQL_Kiwi) follows up on his thorough breakdown of indexed view maintenance with the details of a bug that can render an indexed view incorrect.

Paul White : Indexed View Maintenance in Execution Plans

Paul White (@SQL_Kiwi) provides a very thorough explanation and walk-through of the strategy SQL Server uses to maintain the data in indexed views.

Erin Stellato : Another Reason to Avoid sp_updatestats

Erin Stellato (@erinstellato) of SQLskills explains another reason she avoids the built-in sp_updatestats procedure: it doesn't consider indexed views.