Sql server 2012 query history

SELECT t.[text]
FROM sys.dm_exec_cached_plans AS p
CROSS APPLY sys.dm_exec_sql_text(p.plan_handle) AS t
WHERE t.[text] LIKE N'%something unique about your query%';

Source: stackoverflow.com

Similar codes

4 votes217 views3 answers
Drop Table Oracle
SQL
-1 vote183 views1 answer
Oracle db list usernames
SQL
0 vote221 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote214 views1 answer
Sql server information_schema temp tables
SQL
0 vote217 views1 answer
Mysql grant grant option
SQL
0 vote201 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote221 views1 answer
T-SQL MERGE with condition what is not matched?
SQL
4 votes216 views2 answers
REST API
SQL
1 vote214 views1 answer
Alter constraint postgres
SQL
51 votes346 views6 answers
Opera gx
SQL