create table StatementExecLog
(
    StatementText nvarchar(max),
    LastExecuted datetime,
    ElapsedTimeInSeconds int,
    ExecCountFromLastCompile int
)
go
create proc GetExecutedQueries
    @Filter varchar(8000),
    @DateFrom datetime = '19000101',
    @DateTo datetime = '99990101'    
as
select * from
(
SELECT    SUBSTRING(st.text, (qs.statement_start_offset/2)+1, 
        ((CASE qs.statement_end_offset
          WHEN -1 THEN DATALENGTH(st.text)
         ELSE qs.statement_end_offset
         END - qs.statement_start_offset)/2) + 1) AS StatementText,
        last_execution_time as LastExecuted,
        last_elapsed_time/1000000.0 as ElapsedTimeInSeconds,
        execution_count as ExecCountFromLastCompile
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS st
where last_execution_time between @DateFrom and @DateTo
) t
where StatementText like '%' + @Filter + '%'
order by LastExecuted desc
go
select * from person.address
go
-- for simple searches
exec GetExecutedQueries '.address'
– for long term logging
insert into StatementExecLog
exec GetExecutedQueries '.address'