When writing T-SQL queries, it’s important to reduce the volume of data down as quickly as possible. Larger volumes of data mean more input / output operations (think more reads from and writes to disk), more CPU cycles (hash joins…