Post reply

Forum Etiquette for large sample test data

  • March 25, 2010 at 11:03 am

    #217069

    What is the forum etiquette for large test data sets?

    I have a report that I need some guidance but wanted to find out how I should post it based on Jeff Moden's most excellent post http://www.sqlservercentral.com/articles/Best+Practices/61537/....

    the sample test data is 4000 total rows split between 2 tables.... or should I scale it back some. The sample set is about 10% of the data I will be using.

    thanks in advance

  • March 25, 2010 at 11:41 am

    #1139875

    I guess it really depends on why you feel a need to include that much sample data? Can your problem not be described with 10-20 rows? If you truly feel a need to include that much sample data, you would be best served by creating the sql statements to create all of that data, but instead of posting it directly in the question you might want to attach it as a text file. That way we don't have to wait for a whole lot of data to post to the screen and will probably be much more likely to help...

    But that's just my $.02.

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • March 25, 2010 at 11:52 am

    #1139886

    I could scale back but there might be a need for more test data.... I will start with 25 rows and if more is needed, I will just have to add.... I will be posting pretty soon.... thanks

  • March 25, 2010 at 12:28 pm

    #1139931

    Please keep in mind that you should not post real data.

    And if you have a query to auto-generate those 4k rows you could just post that query so we can populate the data on our system.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

  • March 25, 2010 at 12:29 pm

    #1139932

    I am in the process of modifiying to protect the innocent 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

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