Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Query of 100 mil rows with multiple parameters RE: Query of 100 mil rows with multiple parameters

  • March 5, 2014 at 4:23 am

    #1694227

    ChrisM@Work (3/5/2014)

    GilaMonster (3/5/2014)

    A column cannot be present in an index twice.

    Yes I know but...

    Not 'cannot be specified twice', actual 'cannot be present twice', so precluding SQL putting a column there a second time implicitly.

    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