Home Forums SQL Server 2014 Development - SQL Server 2014 Partitioning Table Strategie RE: Partitioning Table Strategie

  • October 5, 2015 at 5:25 am

    #1831334

    ps_vbdev (10/5/2015)

    Oh OK

    somehow ive picked this up wrong. I was under the impression that partitioning the data would give benefit in the form of sql server not having to look at the older data. So for my case of 50 million records, would i be better to re-index the table on the date field?

    Probably but, to be sure, can you post the CREATE TABLE statement (along with indexes and keys) for the current condition of the table and the most commonly used query(ies)?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)