use mytest
drop table t1000
go
CREATE TABLE t1000
(
c1 INT IDENTITY(1,1) NOT NULL,
c2 VARCHAR(100) NOT NULL
)
GO
set nocount on
DECLARE @rows INT
DECLARE @row INT

SELECT @rows = 1000
SELECT @row = 0

WHILE @row < @rows
BEGIN
	INSERT INTO t1000
		(
		c2
		)
		VALUES
			(
			REPLICATE('a',100)
			)
	SELECT @row = @row + 1
END
go
drop table t10m_1
go
CREATE TABLE t10m_1
(
c1 INT IDENTITY(1,1) NOT NULL,
c2 VARCHAR(100) NOT NULL
)
GO
set nocount on
DECLARE @rows INT
DECLARE @row INT

SELECT @rows = 10000000
SELECT @row = 0

WHILE @row < @rows
BEGIN
	INSERT INTO t10m_1
		(
		c2
		)
		VALUES
			(
			REPLICATE('a',100)
			)
	SELECT @row = @row + 1
END
go