With all the cheerleading and the steady drumbeat of new features being released to Azure, it’s easy to lose track of the many cool and valuable new features released in the on-premises version of SQL ...

Merge joins are not currently part of the heuristics. • Batch-mode memory grant feedback: Previously, SQL Server took a cardinality estimate for a given T-SQL batch and then estimated the minimum ...