Explanation:SET SHOWPLAN_XML causes SQL Server not to execute Transact-SQL statements. 2. Point out the correct statement :
A. SET SHOWPLAN_TEXT causes Microsoft SQL Server to execute Transact-SQL statements
B. The setting of SET SHOWPLAN_ALL is set at execute or run time and not at parse time
C. The setting of SET SHOWPLAN_XML is set at execute or run time and not at parse time
D. None of the mentioned
Answer:A
Explanation:SET SHOWPLAN_XML causes SQL Server not to execute Transact-SQL statements. 2. Point out the correct statement :
A. SET SHOWPLAN_TEXT causes Microsoft SQL Server to execute Transact-SQL statements B. The setting of SET SHOWPLAN_ALL is set at execute or run time and not at parse time C. The setting of SET SHOWPLAN_XML is set at execute or run time and not at parse time D. None of the mentioned
Explanation:When SET SHOWPLAN_XML is ON, SQL Server returns execution plan information for each statement without executing it 3. ___________ displays the profile information for a statement.