Pages

Wednesday, August 21, 2013

SQL SERVER – SP Performance Improvement without changing T-SQL | Journey to SQL Authority with Pinal Dave

There are two ways, which can be used to improve the performance of Stored Procedure (SP) without making T-SQL changes in SP. Do not prefix your Stored Procedure with sp_. In SQL Server, all system SPs are prefixed with sp_. When any SP is called which begins sp_ it is looked into masters database first… Continue Reading...

Source: SQL SERVER – SP Performance Improvement without changing T-SQL | Journey to SQL Authority with Pinal Dave

No comments:

Post a Comment