For the last 6 weeks i'm working for a new customer. The project we are working on consist of 20 to 25 developers. Some of the code I have seen are too awful. For example: functions with 600 lines, use of hungarion name concention, no comments, bad name conventions.
No hungarion notation please! Read :
Code review and refactoring code is really needed here. I'm afraid the project leader dont' see the problem yet. But in the long term the business will have to deal with spending more money to get equal functionality. I will have to convience him that this is high priority to improve the quality of the application..
References:
Always wanted intellisense in Query Analyzer? Go to the website of red-gate and try it out. The download is free till 1st of september.
SQL Prompt is also known as PromptSQL sold by Atadore SARL.
A short summary:
- Just press CTRL + SPACE to trigger intellisense. Althought it don't work perfectly sometimes;
- Recognizes related tables in a join. Note that JOIN functionality only works if you have table relationships explicitly defined in your database;
- Automatically uppercase keywords such as: select , from and etc;
- Inserts your own predefined code snippets
Related links:
