Home Forums SQL Server 2014 Development - SQL Server 2014 HI...Sample INSERT statement script needed to insert 500 million rows into in-memory table sql server 2014 RE: HI...Sample INSERT statement script needed to insert 500 million rows into in-memory table sql server 2014

  • July 31, 2014 at 8:16 am

    #1734092

    GilaMonster (7/31/2014)

    Please remember that the point of in-memory is to improve *massively concurrent* inserts, not single inserts of large numbers of rows. If you don't have massive numbers of concurrent inserts (lots and lots and lots and lots of small inserts), you may be looking at the wrong feature.

    Very good. I'm glad you brought that one up.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events