Great points. I'd just add to point 5 that you should use aliases with meaningful names. I hate seeing aliases with one or 2 letter. Like what the hell is ebd? Turns out it's an alias for the EmployeeBusinessDepartment table. :)