Hi is anyway I can correlate SQL HASH with query store in in SQL server?
I tried collect SELECT H,SUBSTRING(ST,1,4000) FROM ignite.CONST_001
and
SELECT
[qsq].[query_id],
[qst].query_sql_text
FROM [sys].[query_store_query] [qsq]
JOIN [sys].[query_store_query_text] [qst] ON [qsq].[query_text_id] = [qst].[query_text_id]
group by [qsq].[query_id], [qst].query_sql_text
copy paste data in excel and later using query editor by merge SUBSTRING(ST,1,4000) and [qst].query_sql_text
I get much for 50% of query_id using this metod ,but goal is to have full much
any suggestions?
Thank
Alex
