Home Forums SQL Server 2014 Administration - SQL Server 2014 How a new partition Function apply for Current Data RE: How a new partition Function apply for Current Data

  • May 3, 2015 at 4:40 am

    #1795225

    MadAdmin (5/3/2015)

    I think the improvement is solely due to the changing of the clusterd index to be the date key as the non clustered index on date probably would not have been used

    This, exactly.

    If you want to claim the performance improvement is due to partitioning, then the clustered index and nonclustered index keys need to be the same before and after. Otherwise you're comparing apples and lemons.

    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