
Obtaining Actual & Estimated Execution Plans for SQL Queries
Ever wondered if you could determine how the SQL Statements will be executed? Well, now you can in two ways: Getting this information whilst not running any queries with SET SHOWPLAN_XML Getting this information whilst running all queries with SET STATISTICS XML Here is a small example of each: —