You are troubleshooting query performance on SQL Server 2008. You are tasked to create an estimated execution plan by using Transact-SQL. You should be able to view the plan graphically in SQL Server Management Studio. You need to ensure that the execution plan can be saved as a .sqlplan file.
Which Transact-SQL setting should you use?
A.
SET SHOWPLAN_ALL ON;
B.
SET SHOWPLAN_XML ON;
C.
SET STATISTICS XML ON;
D.
SET STATISTICS PROFILE ON;