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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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