My Technical Notes

Thursday, 19 June 2014

Showing Query Plan Text in SQL Server Managment Studio

Execute the statement:

SET SHOWPLAN_TEXT ON

Thereafter you can always set it to OFF.

Also select the Results to Text option, so it doesn't appear in a table.

See Displaying Execution Plans for more information.

No comments: