Guest User

Untitled

a guest
Jan 22nd, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. SELECT qsq.query_id,
  2. qsq.object_id,
  3. qsqt.query_sql_text,
  4. Cast(qsp.query_plan AS XML) AS QueryPlan
  5. FROM sys.query_store_query AS qsq
  6. JOIN sys.query_store_query_text AS qsqt
  7. ON qsq.query_text_id = qsqt.query_text_id
  8. JOIN sys.query_store_plan AS qsp
  9. ON qsp.query_id = qsq.query_id
  10. WHERE qsq.object_id = Object_id('dbo.ProductTransactionHistoryByReference')
Add Comment
Please, Sign In to add comment