Most of the programming I do is in Access. I like to use naming conventions for all my tables, queries, etc. I am now moving several databases to SQL Server. Does anyone know of a good resource for naming convetions in SQL Server. Website, book?
Use a naming convention that makes your code read as much like an English language sentence as possible.
I've never had any use for "tblTableName" or "SP_MyProcedure", or "SomeData_View". It focuses attention on the internal workings of SQL Server when you or the person debugging your code should be focused on the logic and the business rules.
And no unnecessary aliases, please!
Select MT.MyField, YT.YourField from MyTable MT inner join YourTable YT on MT.PKey = YT.Pkey????
If it's not practically useful, then it's practically useless.