Views : 37 Clicks : 0

SQL Bulk copy method to insert large amount of data to the sql database

By nisha_singh via www.codeproject.com
Submitted On January 4, 2012

I was recently tasked with a project at a company to update an SQL Server 2008 database with large amounts of data each day. The task at first seemed daunting due to the files exceeding well over 400,000 records and there were several that needed processing daily. I first tried LINQ to SQL, but with the amount of data, the inserts were slow performing to say the least.

  0 Comments   Tags: Tutorials,  Database

Freshly Arrived

1. Recovery software for memory card
2. Replicating MySQL AES Encryption Methods With PHP
3. Auto start Session in PHP
4. 55 of the Best Responsive WordPress Themes
5. PSR-1 and PSR-2 to be Approved as Standards

Getting Hotter

1. Check Network Status using HTML5 and javaScript
2. Use standard PHP functions in eZ Publish