drop database miketest
go

CREATE DATABASE [miketest]
 ON  PRIMARY 
( NAME = N'miketest', FILENAME = N'S:\sqldata\miketest.mdf'  )
 LOG ON 
( NAME = N'miketest_log', FILENAME = N'S:\sqldata\miketest.ldf', FILEGROWTH = 10%)

go
-- grow DB in 1MB increments
--ALTER DATABASE [miketest] MODIFY FILE ( NAME = N'miketest_log', FILEGROWTH = 1024KB )
-- grow DB in 1GB increments
--ALTER DATABASE [miketest] MODIFY FILE ( NAME = N'miketest_log', FILEGROWTH = 1048576KB )
-- grow DB in 8GB increments
--ALTER DATABASE [miketest] MODIFY FILE ( NAME = N'miketest_log' , FILEGROWTH = 8388608KB )


GO
use miketest
go

use  miketest
go
create table vlf_test (
vlf_id int identity primary key not null,
vlf_int int,
vlf_guid1 uniqueidentifier,
vlf_guid2 uniqueidentifier,
vlf_guid3 uniqueidentifier,
vlf_guid4 uniqueidentifier,
vlf_guid5 uniqueidentifier,
vlf_guid6 uniqueidentifier,
vlf_guid7 uniqueidentifier,
vlf_guid8 uniqueidentifier,
vlf_guid9 uniqueidentifier
)

create index ix_guid1 on vlf_test(vlf_guid1)
go
create index ix_guid2 on vlf_test(vlf_guid2)
go
create index ix_guid3 on vlf_test(vlf_guid3)
go
create index ix_guid4 on vlf_test(vlf_guid4)
go
create index ix_guid5 on vlf_test(vlf_guid5)
go
create index ix_guid6 on vlf_test(vlf_guid6)
go
create index ix_guid7 on vlf_test(vlf_guid7)
go
create index ix_guid8 on vlf_test(vlf_guid8)
go
create index ix_guid9 on vlf_test(vlf_guid9)
go

--dbcc loginfo ('miketest')

BEGIN TRAN vlftest

DECLARE @i int

SELECT @i = 0

WHILE @i < 5500000
BEGIN
	INSERT vlf_test (vlf_int) VALUES (@i)
	SELECT @i=@i + 1
END

COMMIT TRAN vlftest
go
use master
go
