June 20, 2012 at 10:15 pm
Hi all,
Good morning
Can anybody help me to find the size of data of a query resultset other client_statistics using built-in functions
June 20, 2012 at 11:25 pm
No built-in function to tell you that. Look at the query plan.
June 21, 2012 at 12:28 am
Hi Robert,
Thanks for quick reply
Can u give information on, when we execute a query in SSMS, will it be maintained a record in system tables of master data.
June 21, 2012 at 1:01 am
Queries that are executed and their query plans are cached in memory (with a few exceptions like trvial plans). You can query the Dynamic Management Views and functions (DMVs) to get the information.
Look up the following DMVs in Books Online: sys.dm_exec_requests, sys.dm_exec_sql_text, and sys.dm_exec_cahced_plans.
you can also view the estimated or actual query plans for q query by clicking the appropriate button in the SSMS query menu.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply