Home Forums SQL Server 7,2000 Performance Tuning Sql Server Performance RE: Sql Server Performance

  • January 19, 2012 at 1:19 am

    #1435692

    suresh0534 (1/18/2012)

    Hi,

    If we create Temporay Tables in a Stored Procedure will degrade the performance of the query?

    Maybe, or maybe it'll improve the performance due to been able to process smaller chunks of data. You should probably only use them when they do improve things

    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