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