Clicking on the XML link containing a query plan doesn’t display the graphical plan but opens the XML editor instead

Recent Note: SQL Server 2008 R2 Service Pack 1 Cumulative Update 4 (10.50.2796.0) is the first build servicing showplanxml.xsd with the updated version. So, install that CU to get rid of this problem. Last week, while working with a customer in the optimization of some of his queries, he raised to my attention that his…

1

How to tell from ShowPlan output if (optimize for (unknown)) was used?

This one question someone asked me recently. In SQL Server 2005, 2008, and 2008 R2 there’s no difference between the ParameterList node generated for a parameterized query optimized for the parameter’s runtime value and the ParameterList node generated for the same query parameterized for UNKNOWN. For the query engine, a parameter for which the UNKNOWN…

0