Whitepaper editing (sigh)

Hi Folks,

I posted a day or so back about the whitepaper on plan caching and recompilation being published.

Today I had a query from a reader and found that the editor has messed up an example.

For example, I had this example of a query that’s almost identical but where the query plan would be different:

SELECT ProductID  
FROM Sales.SalesOrderDetail  
GROUP BY ProductID  
HAVING AVG(OrderQty) > 5  
ORDER BY ProductID;

SELECT productid  
FROM Sales.SalesOrderDetail  
GROUP BY ProductID  
HAVING AVG(OrderQty) > 5  
ORDER BY ProductId;

“Helpfully” the editor changed it to:

SELECT ProductID  
FROM Sales.SalesOrderDetail  
GROUP BY ProductID  
HAVING AVG(OrderQty) > 5  
ORDER BY ProductID;

SELECT ProductID  
FROM Sales.SalesOrderDetail  
GROUP BY ProductID  
HAVING AVG(OrderQty) > 5  
ORDER BY ProductID;

And undid the point of the example…

2013-03-19