DaveWentzel.com            All Things Data

List of DMFs and Purpose


returns the XML query plan for a given plan_handle (XML Query Plans)
dm_exec_text_query_plan new in 2005 SP2.  Similar to dm_exec_query_plan but eturns output in text format and allows you to specify individual statements in a batch.  Requires plan_handle and optional start and end offsets. 
a DMF that returns a table containing a list of suggested columns needed to build the specified missing index. 

Add new comment