daily pastebin goal
36%
SHARE
TWEET

Untitled

a guest Jan 22nd, 2019 64 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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')
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top