Post reply

Loop till max size

  • August 19, 2014 at 10:42 pm

    #298489

    Hi,

    I have a requirement like need to loop the records until it reaches the max size of the database.

    Say currently my database size is 1 GB i need to increase the size to 3 GB so i am having a script to increase the size but not to 3 GB it will increase the database size in KB's , so now i need to loop through the records until it reaches 3 GB.

    some thing like

    set @maxsize=3

    while @size is <=@maxsize

    begin loop

    --- my statements

    end loop

    since it deals with size , can we do it in loop?

  • August 19, 2014 at 11:50 pm

    #1739465

    Is this a test database where you need to just generate a bunch of random records? Jeff Moden has an article or two on it I'm sure. Chris Morris schooled me on how to do it too. Could you provide details (table structures?) so we know what you're dealing with?

    These two articles should get you started:

    Generating Test Data, Part 1 [/url]

    Part 2 [/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply