Why would a stored procedure perform differently when executed remotely to locally?

Why would a stored procedure perform differently when executed remotely to locally?

We’ve a stored procedure that happens to build up some dynamic SQL and execute via a parametrised call to sp_executesql.
Under normal conditions, this works wonderfully, and has made a large benefit in execution times for the procedure … Read the rest “Why would a stored procedure perform differently when executed remotely to locally?”

SQL Server Management Studio problem creating scripts of procedures

SQL Server Management Studio problem creating scripts of procedures

The stored procedure scripts that SQL Server Management Studio 2005 generates for me are like:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[APY_SP_ACH_Transmit_Finish]’) AND type in (N’P’, N’PC’))
BEGIN
EXEC … Read the rest “SQL Server Management Studio problem creating scripts of procedures”