70-762 Exam QuestionsBrowse all questions from this exam

70-762 Exam - Question 166


You have multiple queries that take a long time to complete.

You need to identify the cause by using detailed information about the Transact-SQL statements in the queries. The Transact-SQL statements must not run as part of the analysis.

Which Transact-SQL statement should you run?

Show Answer
Correct Answer: B

SET SHOWPLAN_TEXT ON causes Microsoft SQL Server not to execute Transact-SQL statements. Instead, SQL Server returns detailed information about how the statements are executed. This allows you to analyze the execution plan without running the queries.

Discussion

1 comment
Sign in to comment
lh2607
Nov 19, 2020

Correct