It is best to avoid using the * operator in your queries, use explicit column names instead.
SQL Server scans through all column names and replaces the * operator with all the column names of the tables.
Visit the DevX Tip Bank