SQL Server 2012 SP2 CU7 released

Hot on the heels of the recent security updates, we’ve got Cumulative Update 7 for SP2.

Some of the interesting fixes include:

  • Hash or merge join hints may be ignored
  • Indexed view returns incorrect result after insert or delete operation on the base table
  • Incorrect results occur in a rare scenario when you run a query that contains a nested loop join and performance spool in its inner side
  • Schema lock occurs on a table with large data when you delete lots of rows (involves full text indexing)
  • Access Violation error occurs when you run DDL SQL statements
  • Incorrect result when you execute a full-text query with parallel execution plan
  • CMEMTHREAD waits occur when you execute many ad hoc queries

Leave a comment

Your email address will not be published. Required fields are marked *