Put the query in a new query window in SQL Server Management Studio ... By putting your mouse over the Key Lookup icon within the execution plan, you can see the output list shown in Figure ...

[Click on image for larger view.] A Query (with Typo) Translated to SQL and Execution Results (source: Microsoft). In fact, some standard best practices are already being shared: Least privilege -- ...

A common SQL habit is to use SELECT * on a query, because it’s tedious to list all the columns you need. Plus, sometimes those columns may change over time, so why not just do things the easy way?

Put the query in a new query window in SQL Server Management Studio ... By putting your mouse over the Key Lookup icon within the execution plan, you can see the output list shown in Figure ...