SQL 优化
http://msdn.microsoft.com/en-us/library/cc645993(v=sql.110).aspx
from Alex Feng (privately):
标准版不支持数据压缩
from Alex Feng (privately):
MAXDOP hint: http://msdn.microsoft.com/en-us/library/ms181714.aspx
设置MAXDOP = 1只用一个CPU CORE
from Alex Feng (privately):
比如:
from Alex Feng (privately):
SELECT ProductID, OrderQty, SUM(LineTotal) AS Total
FROM Sales.SalesOrderDetail
WHERE UnitPrice < $5.00
GROUP BY ProductID, OrderQty
ORDER BY ProductID, OrderQty
OPTION (MAXDOP 1);