Before this week, my knowledge of SQL was essentially limited to "SELECT blah FROM blah JOIN blah ON blah WHERE blah". Now I'm being asked to do a little more, and while I think I'm getting up to ...

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 ...