Jeff Moden wrote:
Totally agreed about the usefulness of standards but I have to say that bad standards are as bad and sometimes worsen than no standards.
Agreed, but what's much worse is if you get a new developer coming into a project and they single-handedly decide that their naming conventions are better than the ones used in the project then they start using them and ignoring the project standards, then you have a project with two different standards.
I don't have much of an issue with aliases, they should be as short as possible, because all you need to do is take a quick look at the FROM then hold a few letters in your head while you look at the rest of the query. It is nice to abbreviate to the letters first letter of each word (as Jeff does) then it's obvious when you look at the query which tables the aliases refer to.
What really annoys me is when no aliases used in a query or they are used but columns aren't prefixed with the alias, it can be a lot of effort to work out which table individual columns are from if there is no aliasing in the query.