alter database test set recovery BULK_LOGGED
go
insert into aaa
select id=a.id+b.id+c.id+d.id +e.id +f.id+g.id
from(
select id=0 union all select 1
union all select id=2 union all select 3
union all select id=4 union all select 5
union all select id=6 union all select 7
union all select id=8 union all select 9
) a,(
select id=0 union all select 10
union all select id=20 union all select 30
union all select id=40 union all select 50
union all select id=60 union all select 70
union all select id=80 union all select 90
) b,(
select id=0 union all select 100
union all select id=200 union all select 300
union all select id=400 union all select 500
union all select id=600 union all select 700
union all select id=800 union all select 900
) c,(
select id=0 union all select 1000
union all select id=2000 union all select 3000
union all select id=4000 union all select 5000
union all select id=6000 union all select 7000
union all select id=8000 union all select 9000
) d,(
select id=0 union all select 10000
union all select id=20000 union all select 30000
union all select id=40000 union all select 50000
union all select id=60000 union all select 70000
union all select id=80000 union all select 90000
) e,(
select id=0 union all select 100000
union all select id=200000 union all select 300000
union all select id=400000 union all select 500000
union all select id=600000 union all select 700000
union all select id=800000 union all select 900000
)f,(
select id=0 union all select 1000000
union all select id=2000000 union all select 3000000
union all select id=4000000 union all select 5000000
union all select id=6000000 union all select 7000000
union all select id=8000000 union all select 9000000
)g
go
go
insert into aaa
select id=a.id+b.id+c.id+d.id +e.id +f.id+g.id
from(
select id=0 union all select 1
union all select id=2 union all select 3
union all select id=4 union all select 5
union all select id=6 union all select 7
union all select id=8 union all select 9
) a,(
select id=0 union all select 10
union all select id=20 union all select 30
union all select id=40 union all select 50
union all select id=60 union all select 70
union all select id=80 union all select 90
) b,(
select id=0 union all select 100
union all select id=200 union all select 300
union all select id=400 union all select 500
union all select id=600 union all select 700
union all select id=800 union all select 900
) c,(
select id=0 union all select 1000
union all select id=2000 union all select 3000
union all select id=4000 union all select 5000
union all select id=6000 union all select 7000
union all select id=8000 union all select 9000
) d,(
select id=0 union all select 10000
union all select id=20000 union all select 30000
union all select id=40000 union all select 50000
union all select id=60000 union all select 70000
union all select id=80000 union all select 90000
) e,(
select id=0 union all select 100000
union all select id=200000 union all select 300000
union all select id=400000 union all select 500000
union all select id=600000 union all select 700000
union all select id=800000 union all select 900000
)f,(
select id=0 union all select 1000000
union all select id=2000000 union all select 3000000
union all select id=4000000 union all select 5000000
union all select id=6000000 union all select 7000000
union all select id=8000000 union all select 9000000
)g
go
alter database test set recovery full