July 11, 2014 at 4:43 am
Hi Folks,
I have created database which has 1 file group with 4 data files, where two data files are created in separate drives.. I have a flat file having 40 million rows that needs to be inserted in to this database.
The issue is the space used in data files is not uniform, In fact only one data file is getting used to store the data and other 3 data files are just empty.
Please let me know what could be causing this issue and resolution for this problem. please let me know if more details are required.
Thanks
Vinay
July 11, 2014 at 9:01 am
How are you loading the data?
Is all the data going to one table or to multiple tables?
Are the tables heaps or do the have clustered indexes?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 13, 2014 at 7:34 pm
Hi,
I am loading data using Bulk Insert method using SSIS. All data is loaded in to single table. On Indexes I am dropping all indexes before insert.
Regards,
Vinay
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply