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

Hi there,<BR><BR>I've got a little problem. I need to join two tables both have the field "Product_ID" but the contents of the columns differ slightly. For example:<BR><BR>Table 1<BR>Field: Product_ID ...