I wrote the function in the code below to quickly generate number tables.
It executed this code to load a table with 1,000,000 numbers in 6.780 seconds. When I ran it to load a table with 10,000,000 numbers, it took about 136 seconds. 100,000 rows took 0.610 seconds, and 10,000 rows took 0.063 seconds.
declare @t datetime declare @n table( number int ) set @t = getdate()
insert into @n select number from -- Function F_TABLE_NUMBER_RANGE available on this link -- http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47685 F_TABLE_NUMBER_RANGE(1,1000000)
select ElapsedTime = getdate()-@t