Viewing 9 posts - 1 through 9 (of 9 total)
June 30, 2017 at 7:23 am
Thank you Hugo Kornelis and Grant Fritchey
Based on your responses I think I found what I need to do to overcome this problem
January 21, 2016 at 5:46 am
My suggestion is to use Oracle and take this conversation to an Oracle forum.
Thank you,
But I deeply believe that Microsoft has a solution for such occasions.
January 21, 2016 at 5:28 am
Guys! please!
We CANNOT have much indexes in the tables (neither one table for each month, nor 10,000 tables!)
because data is bulking into the tables! 1000 records on each bulk! having...
January 21, 2016 at 5:20 am
Do any of the files that you load have the same structure? If so, why not put them into the same table? And why create a new database each month?
Because...
January 21, 2016 at 4:46 am
150G gets considered huge if you have it per months!
Look, there's no other choice for designing a perfect structure in such occasion.
There are load of huge files (each file up...
January 21, 2016 at 4:09 am
Thanks for the elaboration
But there are some problems with creating a unique index based on five columns:
Firstly, I'm dealing with huge amount of data which is required to get bulked...
January 21, 2016 at 3:37 am
I didn't quite get you, you mean set all those 5 columns as primary keys?!
If so, I think when it comes to 50,000,000 record check, that's a terrible idea from...
January 21, 2016 at 3:07 am
Thanks guys,
Sorry I'm new in this forum, I don't know how to post 'sample data', But what BWFC generated as data exactly represents my situation! I just got millions...
December 1, 2014 at 7:34 am
Viewing 9 posts - 1 through 9 (of 9 total)