THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » NOEXPAND   (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
  • Connect Digest : 2010-02-16

    Simon Sabin has asked for better usability in the SQL Server Agent log viewer: specifically, to allow you to get to job / step properties directly from the history viewer. #531889 : Allow access to job details from the log file viewer to improve manageabilityGuru Itzik Ben-Gan asks for a more powerful QUALIFY() option to allow filtering on the ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on February 15, 2010
Privacy Statement