SQLTeam.com | Weblogs | Forums

SQL Query Updating


Does anyone aware of a tool or technique to quickly change the tbl names etc...that helps in anonymizing the SQL query before sharing to get some tuning advice?


SentryOne Plan Explorer is free and has an anonymization feature:

It only modifies the plan, not the actual tables/objects in the database.

If you'd prefer another option, you can open the plan XML in any decent text editor (NotePad++ or Sublime Text are my preferences) and you can replace individual table names pretty easily. You could also use the replace function in SSMS, but it tends to interpret query plans rather than treat them as plain text.

1 Like

Oh boy, SolarWinds :grinning_face_with_smiling_eyes:
100% notepad++

Don't read anything into that, Solarwinds just acquired SentryOne, they still operate independently.