I really don't care what naming standards we have. Let's just make them clear and let's enforce them. After that, it's all good.
I have a presentation where I spend about 20 minutes on this topic. Here's my naming slide:
Names should be descriptive
Procedures should be a phrase
Abbreviations should be common (no Ddltbl)
Use aliases
Clear
Common
Be consistent
A foolish consistency is the hobgoblin of little minds
Keyword in that sentence is “foolish”
Please, anyone who has seen the session, don't give away what ddltbl is.
"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