I am trying to bulk insert a table that is 40 gb. I believe it would be in my best interest to adjust the size of the database to this size before inserting the data, does anybody have an opinion on this? Also, how much time will it take to grow a db from 1 gig to 40 gb.
Thanks so much!