Helpful Hint: Making Review of a Query Plan Easier

I think we all have looked at the output of statistics profile and wished the Estimated Rows and Estimated Executions columns were placed beside the Rows and Executes columns.  Well, they can be.

In grid mode you simply drag the columns beside each other.  

If the output is in text mode the Visual Studio Editor provides the ATL+LEFT MOUSE column selection capability.   Since SQL Server Management Studio is hosted in this shell you can hold down the ALT key while using the mouse to select a column of data.  

Here is what the column selection look like.  Instead of a word or a row highlighted you can select the same column positions vertically in the text data.

image

After the data is highlighted you can copy and paste it next to the rows.

image

Bob Dorr
SQL Server Senior Escalation Engineer