Search: bulk load

SQL2008 R2 DCE on a 96 core Unisys ES7000 server with DSI Solid State storage: Bulk Inserting 1 Terabyte within 10 minutes (2010-8-23)

Category: SQL 2008 R2, Storage: SAN & SSD, Windows 2008 R2 | Tags: , , , | 3 Comments

Hopefully you have seen the high-speed data loading demo live over the last 1.5 years at some SQL Server conference? I remember demoing it the first time –live- with Thomas Kejser at the European SQLPass 2009 conference during the opening keynote to show the 64+ Core support in SQL2008 R2. But for those of you […]

Speeding Up SSIS Bulk Inserts into SQL Server (2010-2-5)

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

Since we set the ETL World Record  with the introduction of SQL2008, a lot of insights, tips & tricks have been published on what it takes to load data fast into SQL (see also the Data loading Performance Guide). The trick described below is one to remember if you are being challenged to load a […]

Better Tag Cloud