Which Transact-SQL setting should you use?

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?

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;



Leave a Reply 0

Your email address will not be published. Required fields are marked *