THE SQL Server Blog Spot on the Web
Welcome to SQLblog.com - The SQL Server blog spot on the web
Browse by Tags
Incorrect Results with Indexed Views
Summary: If you use MERGE, indexed views and foreign keys, your queries can return incorrect results. Microsoft have released a fix for incorrect results returned when querying an indexed view. The problem applies to: SQL Server 2012 SQL Server 2008 R2 SQL Server 2008 The Knowledge Base article does not go into much detail, or ...
Paul White: Page Free Space
February 5, 2013
Be ready to drop your indexed view.
In all-too-many cases an indexed view may solve your short term performance goals but at some later time become counterproductive. So if you choose to use an indexed view, you may need an exit strategy. Let me describe a few common problems with indexed views. Indexed views may increase lock contention. It is very easy to demonstrate. ...
June 2, 2009
Brought to you by