StatCounter

View My Stats

Tuesday, February 5, 2008

Dont use SP_ Prefix while creating the StoredProcedure-SQL Server

Reason:

Dont use sp_ prefix while creating the Storedprocedure.Because it degrades the system performance.while creating like this it first scan the master database...After that only it returns to check our concern database.

No comments: