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