• Fecker Elmar (10/23/2013)


    The problem is fixed in the CTP 2, according this annoucement.

    see:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c69d826d-0994-44bf-8c17-96d5ff805dad/sql14-hekaton-loading-causes-log-space-to-blow-up?forum=sql14inmemtech%5B/quote%5D

    You are still going to have log growth if you load a large amount of data in a single transaction unless you use non-durable table (schema only persisted) as all the inserts will still be logged for durability. I think the best practices for large ETL processes will still hold true for In-Memory OLTP as well.