Whitepaper editing

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…

Leave a Reply

Your email address will not be published.