please bear with me as I'm new to Sql Server.
I have extracted a SQL statement from a trace file using the sql profiler tool. This was for a SharePoint application. The SQL statement includes the stored procedure sp_executesql with a number of scalar variables and I was wondering how
do I get the explain plan that was actually used when executing the sql.
Is there a system view I can query that gives this sort of information?
Many thanks in advance for any help.
View Complete Post