SQL Server with Mr. Denny:

sys.plan_guides

1

January 22, 2009  3:00 PM

Viewing SQL Server Plan Guides



Posted by: Denny Cherry
Code Snippet, Plan Guides, SQL Server 2005, SQL Server 2008, sys.plan_guides

So you've saved a plan guide into your SQL server, and you want to look at the plan.  You can Query the sys.plan_guides catalog view and see the data exactly as you entered it, which works fine if you just have a hint in there.  But if you have a full XML query plan that isn't going to do you a...

1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: