• You can get aggregate information about queries from the dynamic management objects (DMO), specifically by querying sys.dm_exec_query_stats. But, that assumes that the query is still in cache. If it's aged out of cache or recompiled since the time you were interested in, the information won't be there. But, it's not a history of all times that the query ran, just an aggregate.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning