Listing 2: Revised Query That Should Yield Improved Performance

CREATE PROCEDURE [dbo].[UpdateControlCounter]
            @RefNo DECIMAL(19),
            @CurrentPPCC INT,
            @LastEffDate DATETIME,
            @LastRefSeq VARCHAR(4),
            @ExportDttm DATETIME
AS
            UPDATE ControlCounter
            SET CurrentPPC = @CurrentPPCC, LastEffDate = ISNULL(@LastEffDate,'1899-12-31'), 
                        LastRefSeq = @LastRefSeq, 
                        ExportedOn = @ExportDttm
            WHERE RefNo = @RefNo