Home Forums SQL Server 2008 SQL Server 2008 - General Best index structure for table that holds a large amount of log data RE: Best index structure for table that holds a large amount of log data

  • October 31, 2012 at 2:05 am

    #1554503

    1500ms is incredibly high for an insert, unless you're inserting a million or so rows. Can you post more details, including an execution plan?

    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