SQL tip

November 10th, 2009 by Stephen Jones Leave a reply »

A useful tip – when SQL Server executes a stored procedure, it first checks to see if it is a built-in stored procedure (system supplied). It checks the master database for the existence of this procedure. If the procedure is not found, then it will search the user database. In a high transaction environment, the slight performance hit will add up.

If Microsoft creates  a system stored procedure with the same name as the procedure you wrote.then  your procedure will stop working and the one supplied by Microsoft will be executed.

SQL will actually execute the one in the master database

Advertisement

Leave a Reply

You must be logged in to post a comment.