title: Find the number of rows executed from historical query
body: <p>I want to run a query on SQL server logs to get the date of the query execution the text of the query and the number of rows of the results.</p>
  
  <p>I tried so far to use </p>
  
  <pre><code> SELECT  dest.text,deqs.last_execution_time 
  FROM    sys.dm_exec_query_stats AS deqs
          CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
  WHERE   deqs.last_execution_time &gt; '8/22/2017 00:00'
          AND dest.text LIKE '%WorldRecords2%';
  </code></pre>
  
  <p>But there is no rows</p>
  
  <p>Any ideas????</p>