Restricting database objects

In an organization, you might have more than one developer creating a SQL script for the project. It is mandatory to maintain some kind of naming convention rules to maintain consistency and readability. There is a chance that a mistake or lack of co-ordination among developers may occur, so it would be great if we could handle the rules for this kind of naming convention forcefully, by some policy.

Naming the object in the right way is not only necessary for maintaining consistency and readability but also impacts performance, sometimes. So, to avoid performance penalties, restrict the naming convention for database objects. Generally, SP_ is the prefix used for stored procedures in SQL Server (system stored procedure), ...

Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.