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 ...

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 ...