Disagree with the over thinking comment. Names are extremely important. They will color and frame other people's understanding for YEARS to come. 100's, perhaps 1000's of times I've sat somewhere needing to understand someone else's design, and the person training me had to tell me "I know it seems weird - it's called ______, but it really means _______".
First: Too many developers create things as if they were the last people on Earth. Every time you name something, ask yourself whether
the average developer in your shoes would well understand it - not just how well you understand it. Think longer term, think business continuity, think about the reality of the 'next' person.
Second: Too many developers think that object names and variables are all about shortness. Wrong. They're about descriptiveness. Anyone in the dev world these days ought to be a fast typist in the first place. Saving 3 characters of typing isn't your goal. Being able to EASILY remember WHAT that variable means - after you're 2 pages down from the declarations area - is your goal. It is incredibly difficult to come in and be told to refactor TSQL where every temp table is named #temp, every cte is named cte, and every variable is named var.
Third, name scaling. How many times have I foolishly called a Worksheet variable ws, rather than something a bit more descriptive - and then realized I needed to declare 5 worksheet variables. The same principle applies to anything. How often do you begin thinking "this is only going to be 20 lines of code", and the project morphs into a lot more?
Lastly, I like hungarian notation, despite it being considered old fashioned by many. It does the job.
As for the never ending debate about prefixing things like a Table with tbl or whether that's silly because you know it's a table - to me, it depends on the platform. In a platform with awesome intellisense, like SQL Server Management Studio, it might be silly to add "tbl".
However, in a platform like VBA with zero assistance of any kind, it could be helpful - and maybe worth it.
In my personal experience, really thoughtfully named things are absolutely priceless - and if you don't think so, the guy replacing you will.
