THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Indexed View   (RSS)
  • 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 ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on 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. ...
    Posted to Alexander Kuznetsov (Weblog) by Alexander Kuznetsov on June 2, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement