Tag Archive - Performance Tuning

Stored Procedure Naming Convention

November 19, 2008 in Technology with 0 Comments

Never use the sp_ prefix for a user-stored procedure. One reason is that it can make it hard to tell which sprocs are delivered and which are user-defined. Another is that if you prefix your sprocs with sp_, SQL searches for the prefix in the master db each time the procedure is called, before looking in the local database. Use usp_ instead.

From Microsoft eLearning Course 3595: Establishing Database Conventions and Standards for Microsoft® SQL Server™ 2005.

Performance: EXISTS vs LIKE

September 21, 2008 in Technology with 0 Comments

The EXISTS and NOT EXISTS operators can often use an index whereas the LIKE and NOT LIKE operators cause a table scan. This makes EXISTS and NOT EXISTS tend to be more efficient.

Shrinking Databases and Files

June 19, 2008 in Technology with 0 Comments

Shrinking should not be done on a regular basis. Continue Reading…