Post reply

can varchar length decrease perfomance in sqlserver 2005

  • March 8, 2012 at 8:12 am

    #269595

    Dear all,

    I have many stored procedure in my database.

    The problem is, if i use varchar(20) in place of varchar(10) to declare variables,

    then can it decrease performance of my stored procedure or sqlserver 2005

    in any situation.

    (please consider I have more than 300 stored procedure.)

    yours faithfully

  • March 8, 2012 at 8:23 am

    #1456561

    Unlikely to have any noticeable effect.

    My general thoughts around stuff like this is don't fall prey to premature optimisation. Test, measure, tune when necessary. A single missing index will have far more of an effect than any minute differences from variable lengths.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply