Which TransactSQL setting should you use?

You are troubleshooting query performance on SQL Server 2008. You are tasked to create an
estimated execution plan by using TransactSQL.
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 TransactSQL
setting should you use?

You are troubleshooting query performance on SQL Server 2008. You are tasked to create an
estimated execution plan by using TransactSQL.
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 TransactSQL
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 *