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

0 vote141 views1 answer
Postgres drop type
SQL
4 votes192 views2 answers
Mysql alter table set column unique
SQL
0 vote143 views1 answer
Longtext sql
SQL
5 votes156 views1 answer
Oracle list days between two dates
SQL
6 votes160 views3 answers
Mysql remove user privileges
SQL
0 vote148 views1 answer
Drop procedure sql
SQL
0 vote108 views1 answer
Connection error in mysql workbench
SQL
1 vote131 views1 answer
Table infromation in sql server
SQL
11 votes140 views1 answer
Get ddl materialized view oracle
SQL
0 vote141 views1 answer
Symfony\Component\Debug\Exception\FatalThrowableError : Class 'Doctrine\DBAL\Driver\PDOSqlite\Driver' not found
SQL