This is what I have done

Thank you

I think I need a real server to create those 100 million rows. But I got 1 million rows in 3 seconds or so 🙂

Why tempDB? I'm going to use a DB called my DB for that table. Would it still create the table in tempdb even if I used my own table name?

I'm sorry but I don't see any create table statements?

I want my table to be stored in a separate database, let's call it myDB.

This code is very complex to me...

Thank you 😉

I meant about SANs, do I have to read books about it?

Thanks I will give it a try 🙂

Thanks could you please suggest some studying materials :)?

Cadavre, I don't want the table to be a temporary table. I want an actual table, what changes should I apply?

Lowell, the code you gave me didn't work 🙁

it consumed 20 GBs in the temp DB and the destination table was empty and it took like 2 hours to run....

I need to create a primary key on that new table, should I add something like an identity(1,1) to the script?

Thank you so much 🙂

Thank you so much

I want to create as much real data as possible, so I guess duplicate names are fine given that I have 1,000 fname, 1,000 mname and another...

Thank you but would that create unique rows? I'm sorry I'm still very new to the whole thing.