User:Ab9145654904

SELECT t.text AS query_text, s.last_execution_time, s.execution_count, s.total_elapsed_time, s.total_logical_reads, s.total_logical_writes, s.max_logical_reads, s.max_logical_writes, s.creation_time, s.execution_type_desc, s.last_worker_time, s.last_elapsed_time, s.last_logical_reads, s.last_logical_writes, s.last_clr_time, s.last_physical_reads, s.last_rows_affected, s.last_rows_returned, s.last_rows_read, s.last_transaction_time, s.last_successful_execution_time, s.last_unsuccessful_execution_time, s.execution_result, s.is_cached FROM sys.dm_exec_query_stats AS s CROSS APPLY sys.dm_exec_sql_text(s.sql_handle) AS t WHERE s.last_execution_time >= CONVERT(datetime, CONVERT(date, GETDATE-1)) AND s.last_execution_time < CONVERT(datetime, CONVERT(date, GETDATE)) ORDER BY s.last_execution_time DESC