How to quickly create and populate a table 1GB?

21 Oct 2005 8:57 PM

MittyKom

Hi All

How do i create a table which is as big as 1GB? I have tried some thing
below, but it it taking too long. Is there any quick way to do it? Here is my
sample i have tried and it's taking too long:

CREATE TABLE TableD
( X text)
GO

insert into tableD
values (replicate('h', 500000000))
GO

All i want is to have tableD to be 1GB for testing.
Thank you in advance.

21 Oct 2005 9:05 PM

Jerry Spivey

Do you have the SQL Server 2000 Resource Kit? If so, try DBGen.

See:

http://www.microsoft.com/technet/prodtechnol/sql/2000/reskit/part11/c3961.mspx

HTH

Jerry

If not you could use a WHILE loop or CROSS JOIN to produce your data or some
third-party tool/script.

Show quote

"MittyKom" <Mitty***@discussions.microsoft.com> wrote in message
news:AA5D17A7-D8C9-4781-8882-782ED5EF6507@microsoft.com...
> Hi All
>
> How do i create a table which is as big as 1GB? I have tried some thing
> below, but it it taking too long. Is there any quick way to do it? Here is
> my
> sample i have tried and it's taking too long:
>
> CREATE TABLE TableD
> ( X text)
> GO
>
> insert into tableD
> values (replicate('h', 500000000))
> GO
>
> All i want is to have tableD to be 1GB for testing.
> Thank you in advance.

21 Oct 2005 9:10 PM

Mark

Why dont you load an image into the SQL Server table? You can have really big
images and you only need to insert 2 or 3 rows based on the size of the
image.

-Mark

Show quote

"MittyKom" wrote:

> Hi All
>
> How do i create a table which is as big as 1GB? I have tried some thing
> below, but it it taking too long. Is there any quick way to do it? Here is my
> sample i have tried and it's taking too long:
>
> CREATE TABLE TableD
> ( X text)
> GO
>
> insert into tableD
> values (replicate('h', 500000000))
> GO
>
> All i want is to have tableD to be 1GB for testing.
> Thank you in advance.

21 Oct 2005 9:54 PM

MittyKom

Thanx Mark and Jerry.
I have a jpeg image saved on my disk. How can i insert it into a table?

Show quote

"Mark" wrote:

> Why dont you load an image into the SQL Server table? You can have really big
> images and you only need to insert 2 or 3 rows based on the size of the
> image.
>
> -Mark
>
> "MittyKom" wrote:
>
> > Hi All
> >
> > How do i create a table which is as big as 1GB? I have tried some thing
> > below, but it it taking too long. Is there any quick way to do it? Here is my
> > sample i have tried and it's taking too long:
> >
> > CREATE TABLE TableD
> > ( X text)
> > GO
> >
> > insert into tableD
> > values (replicate('h', 500000000))
> > GO
> >
> > All i want is to have tableD to be 1GB for testing.
> > Thank you in advance.

24 Oct 2005 1:12 PM

JT

Give a little more information about what type of testing you are wanting to
do, and perhaps you will get better advice about how to populate the table.

Show quote

"MittyKom" <Mitty***@discussions.microsoft.com> wrote in message
news:AA5D17A7-D8C9-4781-8882-782ED5EF6507@microsoft.com...
> Hi All
>
> How do i create a table which is as big as 1GB? I have tried some thing
> below, but it it taking too long. Is there any quick way to do it? Here is
> my
> sample i have tried and it's taking too long:
>
> CREATE TABLE TableD
> ( X text)
> GO
>
> insert into tableD
> values (replicate('h', 500000000))
> GO
>
> All i want is to have tableD to be 1GB for testing.
> Thank you in advance.