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 » NOEXPAND » Indexed Views   (RSS)
  • NOEXPAND query hint returns wrong results – CU fix now available

    Three days ago at my current gig we stumbled across a problem where use of the NOEXPAND query hint was causing different results compared to the same query without NOEXPAND. For those that do not know (which, until three days ago, included me) NOEXPAND governs the use of indexed views: The indexed view is not expanded only if the view is ...
    Posted to Jamie Thomson (Weblog) by jamiet on February 4, 2013
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement