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