Home > IT Blogs > SQL Server with Mr. Denny > Easy way to read XML execution plans.
>>VIEW ALL POSTS  

SQL Server with Mr. Denny

«
»
Oct 29 2007   8:00AM GMT

Easy way to read XML execution plans.



Posted by: Denny Cherry
Execution Plan, SQL

Take your XML execution plan and save it to a file with a file extension of sqlplan (such as MyQuery.sqlplan) and double click on it.  It will open in the SQL Server Management Studio and show you the plan in the GUI plan viewer making it much easier to read than the XML version.

  Bookmark and Share     Comment     RSS Feed     Email a friend

Comment on this Post

Leave a comment: