Querying PartitionsCommented on: 9 years ago
(July 20, 2005)
We can also test as follows.
-- without orderdate column join and filter date range -- hash join
FROM Orders AS O
JOIN OrderDetails AS OD
ON O.orderid = OD.orderid
WHERE O.orderdate >= '...
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More