Amen on the aliasing brother.
We've been reviewing some code from developers that not only didn't use aliasing, but used table names instead. Unfortunately they didn't even do that consistently so we end up with
SELECT table.column, dbo.table.column, column
FROM...
We're getting out the hickory stick for the next meeting with this dev team...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning