Monday, April 6, 2009

Update Statistics on SQL 2005 Database

Execute the command Below;


SELECT

sum(cache_plan.size_in_bytes)

FROM sys.dm_exec_cached_plans as cache_plan

outer apply sys.dm_exec_sql_text (cache_plan.plan_handle) as sql_text 

No comments:

Post a Comment

 
span.fullpost {display:inline;}