Each organization has its own coding standards and enforcement rules. It is sometime difficult for DBAs to change the code following code review, as it may affect many different layers of the application. In large organizations, many stored procedures are written and modified every day. It is smart to keep watch on all stored procedures, at frequent intervals, before code comes to final code review. Pre-code reviewing in this manner will save lots of time. I run a few scripts every day to check the status of all the stored procedures on our development server. Doing so gives me a good indication about which stored procedures are not up to coding standards.
Read my complete article SQL Server Pre-Code Review Tips
Read SQL SERVER Database Coding Standards and Guidelines Complete List Download
Reference : Pinal Dave (https://blog.sqlauthority.com)
2 Comments. Leave new
iT IS VERY GOOD SITE BUT if supposed we have to go for certification MCDBA , which is the best sit for downloding the dumps .
iT IS VERY GOOD SITE BUT . i ot several god things from this site