• Skip to primary navigation
  • Skip to main content

ROB SYMONDS

  • Home
  • About

Performance Tuning

Stored Procedure Naming Convention

2008-11-19 By Rob Symonds

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

2008-09-21 By Rob Symonds

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

2008-06-19 By Rob Symonds

Shrinking should not be done on a regular basis. [Read more…] about Shrinking Databases and Files

Copyright © 2023 · Log in

  • RSS
  • Twitter
  • LinkedIn