Insertion

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Insertion

Insertion

Rate Topic

Display Mode

Topic Options

Author

Message

Deeptiprasad

Posted Thursday, August 27, 2009 12:20 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 7:22 AM
Points: 171, Visits: 248

Hi,

I need to insert large amount of data into a table lets say some lakhs.

Can anyone please tell me what are the constraints i need to take care of while inserting a large amount of data?

Regards
Deepti

Post #778063

Florian Reischl

Posted Thursday, August 27, 2009 2:15 AM

SSCrazy

Group: General Forum Members
Last Login: Sunday, November 04, 2012 12:23 PM
Points: 2,087, Visits: 3,932

It depends...

You should work with chunks of data (e.g. 100,000 rows in one chunk).
Would it be okay if your tables are locked while insertion? It defines the possible count of rows to be inserted in one chunk.
Depending on your data source you probably should use BCP or SSIS.
It depends on your hardware.

Could you give more specific information, please?

The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems

Post #778099

kramaswamy

Posted Thursday, August 27, 2009 6:46 AM

Right there with Babe

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 12:49 PM
Points: 785, Visits: 1,536

SSIS is very good at handling insertions of large amounts of data. You should definitely consider it.

Post #778229

« Prev Topic | Next Topic »

Permissions