This release of SQL Optimizer for SQL Server is a minor release and includes resolved issues and the following enhancements.
- Improved performance when identifying invalid SQL. This release includes an enhancement to the SQL parsing process which significantly reduces the time required to identify certain invalid SQL statements.
- Syntax support - PIVOT. This release includes support for the PIVOT clause.
- Syntax support - UNPIVOT. This release includes support for the UNPIVOT clause.
Additional information relating to the new features in version 10.1.1 can be found in the SQL Optimizer for SQL Server 10.1.1. Release Notes.