O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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), ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required