SQL Server quick tip

When coding on SQL, make sure to add the FQN of the object, in the long run it will save some cycles to SQL.
Never concatenate strings on the where clause, indexes won't be used.