Source: SQL Server Central - Michael Lato
Everyone should establish some sort of naming convention for their SQL Server platform. It helps to ensure that developers and DBAs can easily find objects and communicate with one another. New author Michael Lato brings us the start of a series on organizing your SQL Server code with an article on naming conventions.
Naming conventions are used to streamline development when multiple developers are working on a single system, as well as to simplify ongoing maintenance during the Development Lifecycle. There are many different naming conventions for SQL Server, and no single convention is necessarily right or wrong. However, a single consistent naming convention should be followed within each database to reduce confusion and enhance usability. Ideally, follow a single naming convention throughout all SQL Servers in an organization.