SQL Server Performance

storage procedure x select

Discussion in 'T-SQL Performance Tuning for Developers' started by psmoreno, Aug 27, 2005.

  1. psmoreno New Member


    If I execute the same select, out storage procedure, the result in the Statistics is double rows number. Why ???

    -- result with select direct
    Rows effected by SELECT statements2727


    -- result with storage procedure
    Rows effected by SELECT statements5454

    Appreciate yours comments
  2. Luis Martin Moderator

    Could you post your sp?.

    Luis Martin
    Moderator
    SQL-Server-Performance.com

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page