It’s real easy to go crazy with best practices and then have them become so big no one follows them.
Here are a just a couple of quick best practices I follow.
1.Whenever you need to recreate a database object use DROP/ CREATE rather than ALTER.
The reason is that ALTER doesn’t modify the object’s create date time stamp.
This makes it harder to trouble shoot when you can’t figure out what has changed recently.
(See this post for how to tell what’s been modified recently.)
2. Adhere to a naming conventions of procedures (uspNAME), views (uvNAME), data/server links (dlNAME/slNAME – crossing servers or databases).
Since code can be in different places in management studio it helps to figure out what bucket you need to look at for your offending code.