DevelopmentNow - Stored Procedures that start with sp

Thursday, September 21, 2006

Stored Procedures that start with sp_

...will run slower, because SQL Server will first check the master database for them. Weird but true, according to SQLMag. So, don't start your procs with sp_.

Database

September 21, 2006

Disclaimer | Comments [1]

Related posts:
Lightweight Remote MySQL Database Access
SQL Server Management Studio - Export Query Results to Excel
List Full Text Indexes in MySQL
Back Up MySQL
Enabling MySQL Logging
Adding Database Columns

« A quick Technorati blog-claiming post | Main | ASP.NET CheckBoxList Validator »

On this page....

Stored Procedures that start with sp_

Blogroll

A1dir

Memoirs of a Bystander

A1dir

About

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

E-mail