In SQL Server 2017, the query optimizer can now sense a bad join choice in a plan and dynamically switch to a better join algorithm during the execution of the code. This addresses some common ...

Other improvements in Beta 2 include the SQL Server Management Studio, scalability and availability enhancements, database encryption, a Business Intelligence Development Studio and new data mining ...