Here is a good blog post on SQL Server coding and naming conventions:

Database coding conventions, best practices, programming guidelines

Views – 3001