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 7:59 am

    #1734079

    I'm also a bit concerned that the table is 195GB with only 500 million records.

    Could you run the script from here and paste the results for that table? It could be the 90 indexes causing bloat, it could be something hidden that is causing the bloat. Or it could be that the table is an extremely wide table. In any case it seems a bit bloated.

    http://bit.ly/tablespace

    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