DMV sys.dm_exec_query_stats already exist before SQL Server Denali. It is now enhanced in CTP3 version with four newly added columns total_rows, last_rows, min_rows, max_rows, which will have some more useful information about query execution.
sys.dm_exec_query_stats
total_rows
last_rows
min_rows
max_rows
Column Description : total_rows - Total number of rows returned by the query. last_rows - Number of rows returned by the last execution of the query. min_rows - Minimum number of rows returned by the query over the number of times that the plan has been executed since it was last compiled. max_rows - Maximum number of rows returned by the query over the number of times that the plan has been executed since it was last compiled.
Published under: SQL Server Tips · · · ·