Hi Team, This is regarding the Adaptive Server Enterprise 15.7.
I am planning to create the new DB Checklist for my development team which will contains few check point\coding guidelines for developer’s which they need to follow \ incorporate in our day to day database development work.
Please let me know do you have any reference for existing DB checklist (mainly for Sybase) or any existing tools which is already available or any reference material which will help me to create this checklist.
For example :- I have documented few check point \ coding guidelines from SELECT statement.
- "SELECT *” should never be used. All the columns that need to be retrieved should be explicitly mentioned.
- Expensive operators such as NOT LIKE should be avoided.
- Avoid cursors, use while loop instead
- Use table variables instead of temp tables when dealing with less data
- Verify the tables used in the SELECT statement.
- Remove the tables from Joins which are not required.
- Use ORDER BY only if you really need the data sorted
- Return only the rows and columns needed
- "Verify usage of DISTINCT – are duplicate rows coming as a result of missing JOIN predicate or data quality issue? "
- Verify usage of IN (…) or NOT IN (…), consider replacing with straight JOIN and/or IF EXISTS.