pooyan_pdm (2/22/2013)
What kind of overhead does this search have?
A lot. That XQuery is heavy on CPU on an unindexed column
Don't do that on a production server. At most, pull the plan cache unfiltered to a table, move the table to another server, do your filtering there.
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