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

1 vote250 views3 answers
How to pass password to mysql command line
SQL
1 vote245 views1 answer
Where not in array sql
SQL
0 vote233 views1 answer
Sql last time database was accessed
SQL
0 vote234 views1 answer
Mssql + bit + in python orm
SQL
0 vote255 views1 answer
Show specific events on mysql
SQL
2 votes221 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote233 views2 answers
Mysql filter by date mount
SQL
0 vote230 views1 answer
Group by sql not ordering issues
SQL
5 votes237 views1 answer
Commentaire table oracle
SQL
4 votes224 views1 answer
Mysql timestamp in laravel migration
SQL