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...
When DBAs and SysAdmins learn the ins-and-outs of AlwaysOn Availability Groups, they’re then able to address high availability and disaster recovery concerns from a single interface or set of tooling, thus providing better scalability of management....More