This chapter describes the new functionality in version 11.9.2. Topics include:
“New locking schemes”
“Changes to table-level locking”
“Changes to statistics and query optimization”
“Enhancements to the create index command”
“Changes and additions to Transact-SQL syntax”
“Configurable database recovery order”
“Fault verification for dbcc checkstorage faults”
“License use monitor”
“Task-to-engine affinity”
“Dynamic SQL performance improvements”
“Direct updates through joins”
“Component Integration Services changes”
“Character set changes”
“Changes that may affect existing applications”
