Home Forums SQL Server 2014 Administration - SQL Server 2014 What's the best practices for storing Very Large Tables? RE: What's the best practices for storing Very Large Tables?

  • January 24, 2015 at 8:39 pm

    #1772931

    I've never worked with Azure but, according to the following article...

    https://msdn.microsoft.com/en-us/library/azure/hh508997.aspx

    ... it looks like you'll need to recombine the individual tables to take advantage of partitioning and you should absolutely take advantage.

    I don't know what the max spec are for Azure but assume from the information in the article linked above that it can easily handle what you're getting ready to throw at it.

    --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)