SSMS Hidden Feature: SHOWPLANTEXT_ALL with Results

SHOWPLANTEXT_ALL with Results

First of all, I’m seeing this feature on SSMS 17, but later I found this feature came with SSMS 2016. So if you found this already then just ignore this.
In earlier versions of SSMS, If we want to get the SHOWPLAN in TEXT or Table format then we can use the SHOWPLAN_ALL query. But it would return only the plan of the query not for the result. But in SSMS 2016 or later we can see this show plan without add any additional query and also it’ll return the result of that query.

Read More