Microsoft released SQL Server 2014 SP2 is available for download. These are the improvements introduced in SQL Server 2014 SP2
- Automatic Soft NUMA partitioning
- Dynamic Memory Object Scaling
- MAXDOP hint for DBCC CHECK* commands
- Enable >8TB for Buffer Pool
- SOS_RWLock spinlock Improvement
- Spatial Native Implementation
- Database Cloning
- Tempdb supportability
- Database Instant File Initialization Logging
- New DMF for incremental statistics
- Index Usage DMV behavior updated
- Support for UTF-8 in BULK INSERT and BCP
- Lightweight per-operator query execution profiling
- Change Tracking Cleanup
- AlwaysON Lease Timeout Logging
- New DMF for retrieving input buffer in SQL Server
- Mitigation for underestimated and overestimated memory grant
- Better memory grant/usage diagnostics
- Query execution diagnostics for tempdb spill
- AlwaysON XEvents and performance counters to troubleshoot latency
- Improved diagnostics for query execution plans that involve residual predicate pushdown
For the detailed list of improvements you may check here
Cheers
Ramasankar Molleti