THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

The Bit Bucket (Greg Low): IDisposable

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

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

Published Tuesday, March 19, 2013 6:10 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

 

Adam Machanic said:

All I can do is laugh with you on this. Been there way too many times...

March 19, 2013 11:20 AM
 

just Me said:

Aren't all 4 of the above queries exactly the same?

March 20, 2013 1:59 PM
 

Greg Low said:

No, the point of the example was the difference in the case of the column ProductID vs productid. The editor "fixed" it for me.

April 25, 2013 9:08 PM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement