In earlier versions of SQL Server, after selecting a join algorithm, SQL Server had to process it even if a better alternative might be available. In SQL Server 2017, the query optimizer can now sense ...

Ahead of Microsoft Build (and a possible SQL Server announcement), let's break down what we know and speculate about what we don't. One topic that has come up in several conversations with customers ...