Slow procedure:
CREATE PROCEDURE GetMeMyData
@param1 NVARCHAR(20)
AS
BEGIN
SELECT id, name, otherstuff
FROM dbo.table1
WHERE param1 = @param1
END
Fast procedure:
CREATE PROCEDURE GetMeMyData
@param1 NVARCHAR(20)
AS
BEGIN
DECLARE @localParam1 NVARCHAR(20)
SET @localParam1 = @param1
SELECT id, name, otherstuff
FROM dbo.table1
WHERE param1 = @localParam1
END
At first I tought it had something to do with an outdated version of SQL Server, but it even occurs on SQL Server 2005 SP3.
1 comment:
Thanks a lot! That's really good to know. I'll keep that in mind!
Post a Comment