Search: bulk load

SQL2014EE ‘Insufficient System Memory’ message (2014-9-1)

Category: SQL2014 | Tags: | 6 Comments

While preparing a data load demo for my presentation at SQLSaturday 317 in Oslo I experienced an hickup with SQL2014 EE: although the server in use for the comparison has 200+GB of RAM assigned to a freshly installed SQL instance, the Bulk inserting command to load a ~75 GByte flat file into an newly created […]

Reading as fast as possible from a table with SSIS (Part II) (2010-5-13)

Category: Performance tip, SQL 2008 R2, SSIS | Tags: , , | 22 Comments

Recently I blogged on how to be as selective as possible while reading from and OLE DB Data Source (Part I) and how to load the data from a single flat file as fast as possible into a SQL Server table. But you probably noticed that “Out of the box” SSIS reads data faster from […]

Better Tag Cloud