Summary
This chapter explored new Transact-SQL elements, extensions, and hints. Some of them are small enhancements that make a developer's life easier and increase her/his productivity. There are also significant operational extensions that increase the availability and deployment of solutions. Finally, two newly added query hints address some rare but serious performance problems caused by incorrect query optimizer estimations and assumptions, where it is hard to find a workaround in previous SQL Server versions.
Get SQL Server 2016 Developer's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
