The wonders of USE PLAN in SQL Server 2005Commented on: 8 years ago
(November 16, 2005)
You are on target about plan guides and the new USE PLAN (plan forcing) hint, except for the following. A plan guide can be used to attach *any* query hint (OPTION clause hint) to a query...
Microsoft seems to be bent on marginalizing SQL Server Standard Edition—both in the sense of the artificial constraints placed upon how much memory it can use, and in terms of what seems to be a shift in focus on the role of Standard Edition from Microsoft....More