• 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