Tip: T-SQL Performance–The * Operator

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

Tip: T-SQL Performance–Owner or Schema Name

In order to improve your queries’ performance, you should always include the owner or schema name of an object by including its prefix before an object. Otherwise, the SQL Server