I was doing some time trials today and couldn't get enough data to really "hurt" the procedure, so I hit upon the Cross Join functionality.
Say you want a million+ records and your biggest testing table has only 1000.
All you have to do is Cross Join it to itself and you get 10002 or a million rows, cross join it again and you end up with a billion records
For example:
tblTest has 200 rows. You want 8,000,000 (funny how it worked out)
Select * from tblTest, tblTest as test1, tblTest as Test3
You end up with 8 million records, all from 200!