April 24, 2011 at 11:05 am
In my project i have plan tree and i wanted to clip some subtree and then i want to get exact plan string for that subtree. i can able to get it?
April 24, 2011 at 11:30 am
Errr, can you be more specific please?
If you're talking about the xml form of the query execution plan, you can use XQuery on it
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 25, 2011 at 5:02 am
On the other hand, if you're looking at the text showplan, you'll need to parse it using some other language. Better to get the XML plan.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 25, 2011 at 9:47 pm
When working with those XML plans PowerShell makes it really easy to traverse the nodes as Rob shows here.
@SQLvariantI have a PowerShell script[/url] for you.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply